[postgis-users] import shape or sql to postgres automatically

[zhang zhe]

Hello,
 
Thanks for the link. I tried psql with my computer and it gives the error 
FATAL: Ident authentication failed for user "username" Error and Solution. 
 
I google it, and find the solution could be by modifying the pg_hba.conf file. I modified the file and saved. After I run your code again it comes another error:Could not connect to server: permission denied.
Is the server running locally and accepting
connections on Unix domain socket "var/run/postgresql/.s.PGSQL.5432"Somebody suggested this solution:
 
The permissions on the socket file var/run/postgresql/.s.PGSQL.5432
Ordinarily the postmaster will create the socket as world-writable,
but evidently not this time.  Perhaps you have set a nonstandard value
for "unix_socket_permissions"?  Another possibility is that it's not
the socket file itself, but /var that is mis-permissioned.

I didn´t know how to solve this problem. Do I have to install web server such as apache in my machine? I have used chmod 777 to change the right of var/run/postgresql/.s.PGSQL.5432, but it still doesn´t work.
Can you help me? 
 
Thanks
 


 
> Date: Mon, 13 Dec 2010 12:13:44 +0000
> From: mark.cave-ayland at siriusit.co.uk
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] import shape or sql to postgres automatically
> 
> zhang zhe wrote:
> 
> > Hello,
> > 
> > Does anyone know how to import sql table or shape file to postgres 
> > database automatically?
> > What I did before is:
> > I have shpe file save in C:/users
> > I go to terminal in linux, and go to the directory C:/users
> > C:/users shp2pgsql shapefile.shp > sqlfile.sql
> > I will get sql file saved into c:/users directory. I open the sql file 
> > copy all the sql query. After that I open postgres database, and paste 
> > all the query to sql query window, and run the query. I will have new 
> > table appear in the dabase.
> > 
> > Sometimes the sql table is too large, that I cannot paste them all in 
> > the postgres sql query window. Postgres is always get stuck because of 
> > the query is too large.For instance I have road dataset of whole contry, 
> > and it has really millions of queries. Is there any way to import shape 
> > file or sql table to Postgres database automatically without any manual 
> > work?
> 
> Assuming you have the PostgreSQL client installed on your local Windows 
> workstation, it sounds as if you need to pass the -f option to psql and 
> then use -h to connect to your linux server instead, e.g:
> 
> psql.exe -h mylinuxserver -d mydatabase -U myuser
> -f c:/users/sqlfile.sql
> 
> HTH,
> 
> Mark.
> 
> -- 
> Mark Cave-Ayland - Senior Technical Architect
> PostgreSQL - PostGIS
> Sirius Corporation plc - control through freedom
> http://www.siriusit.co.uk
> t: +44 870 608 0063
> 
> Sirius Labs: http://www.siriusit.co.uk/labs
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101217/e68d4609/attachment.html>