public inbox for [email protected]help / color / mirror / Atom feed
Incomplete 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]> 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 08:26 Peter Eisentraut <[email protected]> parent: 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-21 05:26 P Kapat <[email protected]> parent: 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-21 10:18 Peter Eisentraut <[email protected]> parent: P Kapat <[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