On Feb 20, 11:51 pm, guilla...@lelarge.info (Guillaume Lelarge) wrote:
(...)
> If you are on the same network, just allow your computer to access the
> database server with the pg_hba.conf file.
>
> Otherwise, you can use an SSH tunnel.
Details to the above suggestion for internet connections (also for
future reference):
Under Linux you can just use ssh on the command line. Something like: ssh my_server_ip_here -Nf
-L5433:my_server_ip_here:5432
For help try man ssh
Under Windows, one good way is to use puTTY: http://www.chiark.greenend.org.uk/~sgtatham/putty/
Example on how to open an SSH tunnel using port forwarding with puTTY:
http://www.cs.uu.nl/technical/services/ssh/putty/puttyfw.html
As an alternative to an SSH tunnel you can allow access from the
internet on your DB server. You should know your way around security,
though! If in doubt consult: http://www.postgresql.org/docs/9.0/interactive/runtime-config-connection.html
For this, you need to allow connections from the internet in
postgresql.conf: listen_addresses = '*'
I would advise to restrict internet connections to SSL. Also i would
only enable known IP adress(es) of the client(s). So you would add a
line like this to your pg_hba.conf: # Access for John Doe from home hostssl all myuser
insert_client_ip_here/32 md5
Be sure not to allow unwanted connections from the internet.
Regards
Erwin