Re: help running pgAdmin in debian -lenny

On Feb 20, 11:51 pm, guilla(dot)(dot)(dot)(at)lelarge(dot)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