On Thu, 2011-05-05 at 15:05 -0400, jtke...@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 yo...@middle.com -p 20 3. From Terminal#2 connect to the database via the tunnel: psql -p 5432 mydatabasename -U you12 -h localhost RickC -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
