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 +
> 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
