public inbox for [email protected]
help / color / mirror / Atom feedIncomplete online documentation on conecting via ssh tunnels
4+ messages / 2 participants
[nested] [flat]
* Incomplete online documentation on conecting via ssh tunnels
@ 2008-11-20 00:31 P Kapat <[email protected]>
2008-11-20 08:26 ` Re: Incomplete online documentation on conecting via ssh tunnels Peter Eisentraut <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: P Kapat @ 2008-11-20 00:31 UTC (permalink / raw)
To: pgsql-docs
Hi,
If this is not the correct list for the mail, I can post to a more
relevant one, suggest. Otherwise read on:
There was a discussion on connecting to a postgres server via SSH tunnels here:
http://archives.postgresql.org/pgsql-novice/2008-11/msg00060.php
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]
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Incomplete online documentation on conecting via ssh tunnels
2008-11-20 00:31 Incomplete online documentation on conecting via ssh tunnels P Kapat <[email protected]>
@ 2008-11-20 08:26 ` Peter Eisentraut <[email protected]>
2008-11-21 05:26 ` Re: Incomplete online documentation on conecting via ssh tunnels P Kapat <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Peter Eisentraut @ 2008-11-20 08:26 UTC (permalink / raw)
To: P Kapat <[email protected]>; +Cc: pgsql-docs
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Incomplete online documentation on conecting via ssh tunnels
2008-11-20 00:31 Incomplete online documentation on conecting via ssh tunnels P Kapat <[email protected]>
2008-11-20 08:26 ` Re: Incomplete online documentation on conecting via ssh tunnels Peter Eisentraut <[email protected]>
@ 2008-11-21 05:26 ` P Kapat <[email protected]>
2008-11-21 10:18 ` Re: Incomplete online documentation on conecting via ssh tunnels Peter Eisentraut <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: P Kapat @ 2008-11-21 05:26 UTC (permalink / raw)
To: Peter Eisentraut <[email protected]>; +Cc: pgsql-docs
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Incomplete online documentation on conecting via ssh tunnels
2008-11-20 00:31 Incomplete online documentation on conecting via ssh tunnels P Kapat <[email protected]>
2008-11-20 08:26 ` Re: Incomplete online documentation on conecting via ssh tunnels Peter Eisentraut <[email protected]>
2008-11-21 05:26 ` Re: Incomplete online documentation on conecting via ssh tunnels P Kapat <[email protected]>
@ 2008-11-21 10:18 ` Peter Eisentraut <[email protected]>
0 siblings, 0 replies; 4+ messages in thread
From: Peter Eisentraut @ 2008-11-21 10:18 UTC (permalink / raw)
To: P Kapat <[email protected]>; +Cc: pgsql-docs
P Kapat wrote:
> 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?
Well, if you are enthusiastic enough you can link anything to anything,
but it seems to me that the main point in that section is to work with
the given address and port setup, not to create a new one, so it doesn't
appear to be so important.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-11-21 10:18 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-11-20 00:31 Incomplete online documentation on conecting via ssh tunnels P Kapat <[email protected]>
2008-11-20 08:26 ` Peter Eisentraut <[email protected]>
2008-11-21 05:26 ` P Kapat <[email protected]>
2008-11-21 10:18 ` Peter Eisentraut <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox