You can connect to a PostgreSQL database from your home machine using an SSH tunnel. Here is how it is done using Putty and pgAdmin. The first thing to do is to open an SSH tunnel using Putty:
(If you're using Mac OS X or Linux, you can just open a terminal window and run 'ssh -L 5432:web1.webfaction.com:5432 your_username@web1.webfaction.com')
Link Posted by Tim at August 21, 2008 12:09 PM | TrackBack