psql tunneling thru a middle server

On Thu, 2011-05-05 at 15:05 -0400, jtkells@verizon.net wrote:

Im trying to connect my WS to a postgresql database (destination) via
a middle server
I.e.
WS ----> Middle ----> Database
server server
172.x.2.4 172.x.4.12

I can create a SSH tunnel from my WS to the middle server but not sure
how or if I can make the middle server pass connections to and from my
ws and database. BTW, they run the DB on a non standard postrgres
port. Any help would be appreciated....
Thanks

1. From your WS open two terminal(ssh) windows.

2. From Terminal#1 startup the ssh tunnel using:
ssh -L 5432:database.com:8432 you12@middle.com -p 20

3. From Terminal#2 connect to the database via the tunnel:
psql -p 5432 mydatabasename -U you12 -h localhost

RickC