Re: psql tunneling thru a middle server

On Thu, 2011-05-05 at 15:05 -0400, jtkells(at)verizon(dot)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(at)middle(dot)com -p 20

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

RickC