[postgis-users] Re:pgsql2shp

[Chris Hodgson]

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/20020913/77d7ad74/attachment.html>