ssl tunneling in postgres 8.1
От | P Kapat |
---|---|
Тема | ssl tunneling in postgres 8.1 |
Дата | |
Msg-id | daef5be80811180046x7f31a319kb55c180327550239@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: ssl tunneling in postgres 8.1
Re: ssl tunneling in postgres 8.1 |
Список | pgsql-novice |
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@foo.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? Is this relevant: http://www.postgresql.org/docs/8.1/static/ssl-tcp.html ? foo$ postgres --describe-config | grep ssl ssl postmaster Connections and Authentication / Security and Authentication BOOLEAN FALSE Enables SSL connections. -- Regards PK -------------------------------------- http://counter.li.org #402424
В списке pgsql-novice по дате отправления: