How to use SSH tunnels with pgAdmin?
От | Ken Winter |
---|---|
Тема | How to use SSH tunnels with pgAdmin? |
Дата | |
Msg-id | 36F44F9E9CFA4433BA30E4708EC885D4@KenIBM обсуждение исходный текст |
Ответы |
Re: How to use SSH tunnels with pgAdmin?
Re: How to use SSH tunnels with pgAdmin? |
Список | pgadmin-support |
<div class="Section1"><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">I’m suffering from a lot of dropped connections between pgAdmin and my PG databases, even after verybrief inactivity.</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">Your documentation at <a href="http://www.pgadmin.org/support/faq.php#ConnDrop">http://www.pgadmin.org/support/faq.php#ConnDrop</a> says:</span></font><pclass="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">…you could use a SSH tunnel for PostgreSQL traffic. SSH can be configured to keep the channel open atall times, so that database traffic can be passed even after a prolonged period of inactivity. For information how to configurethis, ask your SSH package's documentation for "tunneling".</span></font><p class="MsoNormal"><font face="Verdana"size="2"><span style="font-size:10.0pt; font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">My problem is, I don’t know how to set up pgAdmin to use my SSH package (PuTTY). At least I think that’smy problem. Can you help?</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">~ TIA</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">~ Ken</span></font></div>
В списке pgadmin-support по дате отправления: