Re: Connecting via ssh tunnel

From: "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: "ben short" <ben(at)benshort(dot)co(dot)uk>
Subject: Re: Connecting via ssh tunnel
Date: 2006-11-24 21:53:20
Message-ID: 200611241353.20882.uwe@oss4u.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday 24 November 2006 12:56, ben short wrote:
> Hi,
>
> I have a postgresql server setup on a Solaris 10 box. I can connect to
> the db via psql from the local machine. What I have been trying to do
> it connect with pgAdmin from my workstation. I have setup the tunnel
> correctly, local port 5432 and destination localhost:5432. Everytime I
> try to connect I get the following message.

I guess the tunnel isn't correct. You connect on the same ports - seems wrong
to me. I'm using a tunnel like this:

ssh -l <user> -L 5555:localhost:5432 <servername>

and then connect psql on the client machine with

psql -h localhost -p 5555 -U <user> <dbname>

Uwe

--
Open Source Solutions 4U, LLC 1618 Kelly St
Phone: +1 707 568 3056 Santa Rosa, CA 95401
Cell: +1 650 302 2405 United States
Fax: +1 707 568 6416

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-11-25 00:04:36 Re: more than one row returned by a subquery used as an expression
Previous Message Leonel Nunez 2006-11-24 21:45:57 Re: Connecting via ssh tunnel