[postgis-users] pgsql2shp

David Garnier david.garnier@etudier-online.com
Fri Sep 13 12:55:21 2002


---------------------- multipart/signed attachment
le ven 13-09-2002 =E0 13:33, staub a =E9crit :
> Hi,
> does anybody know why I can't connect to my own database using
> pgsql2shp?
> Here's the error message:
>         could not connect to server: Connection refused
>         Is the server running on host localhost and accepting
>         TCP/IP connections on port 5432?

It seems that your database isn't configured to accept TCP/IP connection
because:
* it wasn't started with the -i flag or=20
* it is configured to refuse connections: check data/pg_hba.conf.

Also, make sure your connection parameters are correct

> The other way is working fine using shp2pgsql.

shp2pgsql doesn't use the DB, it just parse shapefiles into a list of
insert statements that you can use later to insert data in the DB later.

Best Regards,
David Garnier
--=20
Website: http://dgarnier.etudier-online.com
PGP key: http://www.davidgarnier.com/public_gpg_key.txt

---------------------- multipart/signed attachment
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 241 bytes
Desc: This is a digitally signed message part
Url : http://lists.refractions.net/pipermail/postgis-users/attachments/20020913/45cf5e5f/attachment.bin

---------------------- multipart/signed attachment--