<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2716.2200" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Chris</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=staub@gik.uni-karlsruhe.de
href="mailto:staub@gik.uni-karlsruhe.de">Guido Staub</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, September 13, 2002 6:21
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [postgis-users]
Re:pgsql2shp</DIV>
<DIV><BR></DIV>What I wanted to say is, that <BR><I>shp2pgsql shapefile table
db | psql -d db</I> <BR>is running fine and uploading data is no problem. I
don't get an error message about any TCP/IP problems. <BR>So my problem still
exists, that I can't get my data out of the table into a shapefile.
<BR>Reading the Online Doc there should not be a problem using the dumper.
It's only the <BR><I>pgsql2shp [<options>] <database>
<table></I> <BR>command from the commandline, isn't it? <BR>Thanks
<BR>Guido <BR> </BLOCKQUOTE></BODY></HTML>