> -----Original Message----- > From: Josh Berkus [mailto:j...@agliodbs.com] > Sent: Saturday, February 27, 2010 3:46 PM > To: Ken Winter > Cc: pgAdmin Support List > Subject: Re: [pgadmin-support] How to use SSH tunnels with pgAdmin? > > > > My problem is, I don't know how to set up pgAdmin to use my SSH package > > (PuTTY). At least I think that's my problem. Can you help? > > If regular port 5432 connections to your server are being dropped > frequently, then I'm not sure an SSH tunneled connection is going to > help you. Any network flakiness would affect it equally.
The pgAdmin doc on this says: 'As the officially required solution, ask your network administrator to vastly increase or even better disable TCP/IP connection watchdog timeouts on the PostgreSQL port (usually 5432) to restore RFC compliant protocol behaviour of the firewall.' My host (WebFaction.com) says there is not a way to do this, so I went on to the next part of the pgAdmin paragraph: 'If there's absolutely no way to accomplish this, you could use a SSH tunnel for PostgreSQL traffic. SSH can be configured to keep the channel open at all times, so that database traffic can be passed even after a prolonged period of inactivity. For information how to configure this, ask your SSH package's documentation for "tunneling".' > > Unless the connections are being dropped for some other reason? Like what? (Not a rhetorical question; I know basically nothing about these connectivity issues.) The connections aren't being dropped when I work with my other PG tool, PG Lightning Admin, which does use SSH tunnels. ~ Ken -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support