Re: Incomplete online documentation on conecting via ssh tunnels

[Peter Eisentraut <peter_e(at)gmx(dot)net>]

P Kapat wrote:
> The relevant documentations are (replace 8.3 by 8.2 or 8.1 or...):
> http://www.postgresql.org/docs/8.3/static/ssh-tunnels.html
>
> The concerned command is:
> client$ ssh -L 3333:foo.com:5432 joe(at)foo(dot)com
>
> > From the discussion on the novice list, I came to the conclusion that
> the above command works only when listen_addresses = '*' OR
> listen_addresses = 'a.b.c.d'
> (where a.b.c.d is the IP of foo.com; other IPs can be present too)  is
> set in postgresql.conf.
>
> But in most cases, for security reason, the server is quarantined
> within localhost by setting: listen_addresses = 'localhost'.
>
> In this case, the ssh tunnel does not work. The correct command is:
> client$ ssh -L 3333:localhost:5432 joe(at)foo(dot)com
> OR
> client$ ssh -L 3333:127.0.0.1:5432 joe(at)foo(dot)com

You are absolutely correct.  Someone already pointed this out 
independently, and the 8.4devel documentation has much better 
information on this:

http://developer.postgresql.org/pgdocs/postgres/ssh-tunnels.html