[postgis-users] pgsql2shp can not connect to server

Erwin Poeze erwin.poeze at gmail.com
Wed Oct 29 07:57:16 PDT 2008


Hello,

I'm a newbie to postGIS and worked my way through a tutorial.

In the tutorial a spatial database is created and filled with the
contents of a shapefile (using shp2pgsql).
One of the last steps is to create a new shapefile from the database
using pgsql2shp. The exact command
is "pgsql2shp g4wd us_50", where g4wd is the database name and us_50
the table containing the spatial information.
The response to this command is:

# pgsql2shp g4wd us_50
        could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

I tried all the options like setting the port, hostname and the
geometry table, but nothing helps. The database itself is working
fine.

Does someone have an idea of the error I'm making?

Erwin Poeze



More information about the postgis-users mailing list