pgAdmin III won't connect over ssh tunnel
От | Laramie Crocker |
---|---|
Тема | pgAdmin III won't connect over ssh tunnel |
Дата | |
Msg-id | 420E4EFE.3000206@LaramieCrocker.com обсуждение исходный текст |
Список | pgadmin-support |
Hi Folks, I have searched the archive, and didn't find an answer, so excuse me if this has been addressed already. I have the latest pgAdmin III running on Windoze XP. I set up an ssh tunnel to my server using cygwin's ssh client. ssh -L 5433:remote1:5432 laramie@remote1 I use the cygwin psql client to connect from my localhost: psql --> ssh@localhost --> sshd@remote1 --> postmaster@remote1 with the command psql -h localhost -p 5433 -U laramie mydatabase and this works. Now, with pgAdmin III, I use the GUI, and I select localhost 5433 SSL [no input] and my password I get the Connection refused dialog after a really long time. My questions: 1) is it possible to change the connection timeout? 2) when I sniff the port on 5433 locally, I find that pgAdmin III is sending binary bytes, then hangs. Is pgAdmin III insisting on SSL even though I told it not to? Since this configuration works with the plain old command line client psql, I would assume that it would work with pgAdmin III. I much prefer this port-forwarding setup, since I know and love ssh/sshd and I'm not all that interested in punching another hole in the server's firewall to allow postgress through. Similarly, I know how to get ssh working with certificates, and don't want to have a separate process for installing certs for pg's clients. Thanks, Laramie
В списке pgadmin-support по дате отправления: