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-ayl...@siriusit.co.uk > To: postgis-users@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@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users