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

[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 PM, Charlie Sharpsteen <
charles.sharpsteen at gmail.com> wrote:

> 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 server before the changes take
>> effect.
>>
>> -Steve
>>
>
> Another trick that I use all the time is to tunnel the SQL connection from
> the remote server to my machine:
>
>     ssh -L5432:localhost:5432 <user name>@<remote server address>
>
> Then I can connect to the remote database as if it was running locally and
> there is no need to mess with the pg_hba.conf file and figure out how to
> secure the open port, route communication through firewalls, etc.
>
> -Charlie
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120603/e67e2622/attachment.html>