Menu ▾ ▴

#7 Problem using gshp2pgsql with non-standard port or host

open
Steffen Macke
gpgsql2shp (1)
5
2008-09-17
2007-02-28
Steffen Macke
No

Steven reported a problem using gshp2pgsql with an
IP address:

Shapefile type: Polygon

Postgis type: MULTIPOLYGON[2]

psql: could not connect to server: Connection refused (0x0000274D/10061)

Is the server running on host "???" and accepting

TCP/IP connections on port 5432?

Discussion

  • Steffen Macke

    Steffen Macke - 2007-02-28
    • assigned_to: nobody --> sdteffen
    • summary: Problem using gshp2pgsql with IP address --> Problem using gshp2pgsql with non-standard port
     

  • Steffen Macke

    Steffen Macke - 2007-02-28

    Logged In: YES
    user_id=30248
    Originator: YES

    I think the problem is not with the IP address but with the port number which is not passed to
    psql. This is gshp2pgsql 0.2.0.

    Until a new gshp2pgsql version is released, the PGPORT environment variable can be used as a workaround.

     

  • Steffen Macke

    Steffen Macke - 2007-02-28
    • summary: Problem using gshp2pgsql with non-standard port --> Problem using gshp2pgsql with non-standard port or host
     

  • Steffen Macke

    Steffen Macke - 2007-02-28

    Logged In: YES
    user_id=30248
    Originator: YES

    The host is also not set properly...

     

  • Steffen Macke

    Steffen Macke - 2008-09-17
    • labels: --> gpgsql2shp
     

  • Steffen Macke

    Steffen Macke - 2008-10-01

    I used 127.0.0.1 for testing and had no problems. Could you provide some details?

     
Auth0 Logo