On 6/3/2012 12:33 PM, David Quinn wrote:
Hi List,
I have been using the following approach to load a shapefile into my
database locally:
shp2pgsql -s 2831 -i -I -D D:/test.shp public.test_shapefile | psql.exe
-U postgres -d test_db -h localhost -p 5432
I now want to try to load spatial data into a database in a remote
location. For the second part of my command, I tried the following:
psql.exe -U postgres -P password -d test_db_remote -h 75.75.75.75 -p 5432
I've tried a few variations of this without success. Is there anything
that I am missing?
If it is relevant, psql.exe is on a windows 7 computer, and I am
uploading the data to a postgres database on an ubuntu installation.
The server has to be configured to listen on 75.75.75.75 and to allow
connection over the network device.
Look at your pg_hba.conf and postgresql.conf files. and if you make
changes to these you have to restart the server before the changes take
effect.
-Steve
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
