Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37621=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1W6jdL-0008Ox-LG
 for pgsql-sql@arkaria.postgresql.org; Fri, 24 Jan 2014 16:29:32 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37621=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1W6jdL-00018D-1N
 for pgsql-sql@arkaria.postgresql.org; Fri, 24 Jan 2014 16:29:31 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <adrian.klaver@gmail.com>) id 1W6jdJ-000161-7G
 for pgsql-sql@postgresql.org; Fri, 24 Jan 2014 16:29:29 +0000
Received: from mail-pd0-x22b.google.com ([2607:f8b0:400e:c02::22b])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <adrian.klaver@gmail.com>) id 1W6jdG-0003mU-Ac
 for pgsql-sql@postgresql.org; Fri, 24 Jan 2014 16:29:28 +0000
Received: by mail-pd0-f171.google.com with SMTP id g10so3313957pdj.30
 for <pgsql-sql@postgresql.org>; Fri, 24 Jan 2014 08:29:24 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=message-id:date:from:user-agent:mime-version:to:subject:references
 :in-reply-to:content-type:content-transfer-encoding;
 bh=hMGrIGPy0Ij0ZFgsY5iGJXmL97I7Qehfaj6qeGzCUQo=;
 b=OT/af7PjbzRinoatHkcgbgMEshOHSy38lTCDDhSqS5oj9xhnPyqV9JIZgZA6g0hqQM
 7Slnmyhz+xOkc5ouJs4D3TFZTEXZezKOywnPiJFeoQnB4lX9VPpG8OHDaaQBIw6p6x5M
 is0AqokcjOm654HXlEnzLol77PORbCGouC4YixWEl5oFBLnl06OlV1DQ/DKZPRSpN5I5
 PpNHIJjN46CKl1quff76EvEgQceDYE1GW2suSAniUzI9tDlkB/c1kd2S6M+fxxnZIfCk
 hEQ5ZeiE/Yzagzb20Hd71en2rK5NpHhE3LGJLu1+hzO2AZ2Q/qC+soEz1lD4AizvKAV3
 nCUA==
X-Received: by 10.68.224.34 with SMTP id qz2mr15665645pbc.84.1390580963979;
 Fri, 24 Jan 2014 08:29:23 -0800 (PST)
Received: from panda.site (65-102-187-8.tukw.qwest.net. [65.102.187.8])
 by mx.google.com with ESMTPSA id iq10sm4537463pbc.14.2014.01.24.08.29.22
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Fri, 24 Jan 2014 08:29:23 -0800 (PST)
Message-ID: <52E294D5.2000303@gmail.com>
Date: Fri, 24 Jan 2014 08:29:09 -0800
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:24.0) Gecko/20100101 Thunderbird/24.2.0
MIME-Version: 1.0
To: "minsheng.bai" <minsheng.bai@wellintech.com>,
 pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: consulting the question about the usage about SSH Tunnel function
References: <201401241006209142667@wellintech.com>
In-Reply-To: <201401241006209142667@wellintech.com>
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: 8bit
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 01/23/2014 06:06 PM, minsheng.bai wrote:
> dear all
> i have realized the SSH Tunnel function in the PostgreSQL.i did some 
> work as follow:
> at the server side:
> 1.setup and configure the openssh
> 2.start opensshd
> 3.setup and deploy PostgreSQL
> at the client side:
> 1.setup openssh
> 2.execute command£ºssh -L5555:localhost:5432 
> Administrator@XXX.XXX.XXX.XXX(the 
> <mailto:Administrator@XXX.XXX.XXX.XXX%28the> server IP)
> 3.use psql or pgAdmin to connect the server.
> i succeed.
> but i have a question:
> if i do not execute command:ssh -L5555:localhost:5432 
> Administrator@XXX.XXX.XXX.XXX <mailto:Administrator@XXX.XXX.XXX.XXX>
> but i config the SSH Tunnel tab in the pgAdmin,as follow:
> whether i can connect the server or not .the result i try is failed.
> anyone can help me? thanks a lot.

Well I am not seeing anything that allows you to specify the port that
ssh is listening on at localhost. In the shot in the dark department you
might try:

localhost:5555

> ------------------------------------------------------------------------
> minsheng.bai


-- 
Adrian Klaver
adrian.klaver@gmail.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql