David Bear <[EMAIL PROTECTED]> wrote: > > I'm attempting to run pgsql through a tunnel. [snip]
Through an ssh tunnel, using port-forwarding, I'm guessing? > > Am I missing something obvious? Can you "psql -p 5432" on the machine on which the server is running? Here's what I just did successfully: On local machine, ssh to host running pgsql server: $ xterm -e ssh -L 57000:remote.example.com:5432 remote.example.com & After doing the ssh pass-word/-phrase thing... On local machine: $ psql -U jseymour -p 57000 -h localhost Password: Welcome to psql 7.4.2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit jseymour=> \q $ Worked like a champ. This is using OpenSSH, btw. Jim ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings