[postgis-users] Re:pgsql2shp

[Guido Staub]

OK, I've got it. My problem was that I've started the postmaster with
the pg_ctl script but here I couldn't set the -i flag. So now I'm
starting the postmaster with the postmaster file and here it works fine.

Thanks to all.
Guido

Chris Hodgson schrieb:

> The command 'psql -d db' DOES NOT use TCP/IP sockets to connect to the
> db, it uses unix sockets (by default). Whereas, pgsql2shp DOES use
> TCP/IP sockets. Therefore, the advice that David Garnier gave you,
> still stands. Check your config, or start your database with the -i
> flag to allow tcp connections. Chris
>
>      ----- Original Message -----
>      From: Guido Staub
>      To: postgis-users at postgis.refractions.net
>      Sent: Friday, September 13, 2002 6:21 AM
>      Subject: [postgis-users] Re:pgsql2shp
>       What I wanted to say is, that
>      shp2pgsql shapefile table db | psql -d db
>      is running fine and uploading data is no problem. I don't
>      get an error message about any TCP/IP problems.
>      So my problem still exists, that I can't get my data out of
>      the table into a shapefile.
>      Reading the Online Doc there should not be a problem using
>      the dumper. It's only the
>      pgsql2shp [<options>] <database> <table>
>      command from the commandline, isn't it?
>      Thanks
>      Guido
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20020916/09de6e65/attachment.html>