pgsql（解决问题过程中的资料收集）

pgsql2shp -f kota.shp -h 172.27.1.245 -u oracle bphilir “select distinct(nama),a.the_geom from map_town a, map_province_boundary_polygon b where a.the_geom @ b.the_geom AND (province=’JAWA TENGAH’ OR province=’JAWA TIMUR’ OR province=’YOGYAKARTA’)”

Preparing table for user query… Done.
Initializing… Done (postgis major version: 1).
Output shape: Point
Dumping: XXXXXXX [580 rows].

 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?

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.

'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.