Thread: consulting the question about the usage about SSH Tunnel settings

consulting the question about the usage about SSH Tunnel settings

From
minsheng.bai
Date:
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 server IP)
3.use psql or pgAdmin to connect the server.(dont configure ssh tunnel settings of pgAdmin)
i succeed.
but i have a question:
if i configure ssh tunnel settings of pgAdmin as follows:
172.16.9.102 is the remote server ip,i connect the server failed,i get error:
 When should i  use these settings?can anyone make an example for me?
 
 
 

minsheng.bai
Attachment

Re: consulting the question about the usage about SSH Tunnel settings

From
Dave Page
Date:



On Sun, Jan 26, 2014 at 7:12 AM, minsheng.bai <minsheng.bai@wellintech.com> 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 server IP)
3.use psql or pgAdmin to connect the server.(dont configure ssh tunnel settings of pgAdmin)
i succeed.
but i have a question:
if i configure ssh tunnel settings of pgAdmin as follows:
172.16.9.102 is the remote server ip,i connect the server failed,i get error:
 When should i  use these settings?can anyone make an example for me?

Why have the screenshots been modified? 

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Attachment