X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B35515E3F15 for ; Wed, 18 Aug 2004 23:22:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 42393-05 for ; Thu, 19 Aug 2004 02:22:32 +0000 (GMT) Received: from jimsun.linxnet.com (jimsun.linxnet.com [64.32.196.134]) by svr1.postgresql.org (Postfix) with ESMTP id 27D485E46BF for ; Wed, 18 Aug 2004 23:22:19 -0300 (ADT) Received: by jimsun.linxnet.com (Postfix, from userid 332) id 76F704313; Wed, 18 Aug 2004 22:22:33 -0400 (EDT) To: pgsql-admin@postgresql.org Subject: Re: tunneling through ssh X-Sun-Charset: US-ASCII Reply-To: pgsql-admin@postgresql.org Message-Id: <20040819022233.76F704313@jimsun.linxnet.com> Date: Wed, 18 Aug 2004 22:22:33 -0400 (EDT) From: jseymour@linxnet.com (Jim Seymour) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/174 X-Sequence-Number: 14569 David Bear 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