Re: [DOCS] Incomplete online documentation on conecting via ssh tunnels

2008-11-20 Thread Peter Eisentraut 

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 :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 :localhost:5432 [EMAIL PROTECTED]
OR
client$ ssh -L :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

Re: [DOCS] Incomplete online documentation on conecting via ssh tunnels

2008-11-20 Thread P Kapat 
On Thu, Nov 20, 2008 at 3:26 AM, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
>
> http://developer.postgresql.org/pgdocs/postgres/ssh-tunnels.html

That is much transparent. Would it not be better to link to the
relevant section which describes the listen_addresses and port config
parameters in postgres.conf? For example:

http://developer.postgresql.org/pgdocs/postgres/runtime-config-connection.html

-- 
Regards
PK
--
http://counter.li.org  #402424

-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs