Re: ssl tunneling in postgres 8.1

am Tue, dem 18.11.2008, um 3:46:34 -0500 mailte P Kapat folgendes:
> Hi,
>
> I am reading the documentation from here:
> http://www.postgresql.org/docs/8.1/static/ssh-tunnels.html
>
> I am able to ssh (I use ssh keys) in to foo.com using the username
> joe. My client machine (localhost) is bar.com with username sam (say).
>
> bar$ ssh -L 3333:foo.com:5432 joe(at)foo(dot)com
> [this logs me into foo as joe; here i have access to a database named
> "joe" using the password "joepass"]
>
> So I try to connect to this local port (but remote server) by:
>
> bar$ psql -h localhost -p 3333 joe -U joe -W
> Password for user joe: joepass
> psql: server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
> And on the remote ssh terminal I get the following error:
>
> foo$ channel 3: open failed: connect failed: Connection refused
>
> What am I doing wrong? I don't know if this matters: foo.com (remote)
> runs the 8.1 server and bar.com (my client machine/localhost) runs
> 8.3. What server parameter needs to be tweaked?

I can reproduce it with an 8.3 Server and a 8.1 psql-client. If i try it
in the other direction, i got this:

WARNING: You are connected to a server with major version 8.1,
but your psql client is major version 8.3. Some backslash commands,
such as \d, might not work properly.

I would simply use ssh to login into the remote server and use the local
psql. Is this possible for you? Or install the propper psql-client.

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net