Re: [postgis-users] Loading a shapefile into a postgres database remotely

2012-06-03 Thread David Quinn
I think the problem may have been due to a windows 7 firewall setting. I enabled psql.exe under 'Control Panel\All Control Panel Items\Windows Firewall\Allowed Programs' and this seemed to solve the problem. -David On Sun, Jun 3, 2012 at 1:35 PM, Charlie Sharpsteen < charles.sharpst...@gmail.com>

Re: [postgis-users] Loading a shapefile into a postgres database remotely

2012-06-03 Thread Charlie Sharpsteen
On Sunday, June 3, 2012 10:22:03 AM UTC-7, David Quinn wrote: > > I have already edited the pg_hba.conf and postgresql.conf files and can > connect remotely using pgadmin so I think that is not a problem. > > Charlie, should I include this code in the command that I described > earlier, or is it

Re: [postgis-users] Loading a shapefile into a postgres database remotely

2012-06-03 Thread David Quinn
I have already edited the pg_hba.conf and postgresql.conf files and can connect remotely using pgadmin so I think that is not a problem. Charlie, should I include this code in the command that I described earlier, or is it something that I should run first? -David On Sun, Jun 3, 2012 at 1:12

Re: [postgis-users] Loading a shapefile into a postgres database remotely

2012-06-03 Thread Charlie Sharpsteen
On Sunday, June 3, 2012 10:05:45 AM UTC-7, Stephen Woodbridge wrote: > > 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

Re: [postgis-users] Loading a shapefile into a postgres database remotely

2012-06-03 Thread Stephen Woodbridge
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 in