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 [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
OR
client$ ssh -L 3333:127.0.0.1:5432 [EMAIL PROTECTED]
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
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
