pgcli通过SSH本地转发连接远程服务器上的PostgreSQL DB

概述远程主机(10.64.1.129)需求： 1. 假设远程主机打开了ssh端口2. 启动了PostgreSQL，且监听端口为默认的54323. 远程主机的postgreSQL DB只允许localhost访问 本地主机(10.64.71.6)需求： 1. 安装了pgcli2. 启动命令ssh -qtN -L 10.64.71.6:5432:localhost:5432 10.64.1.129 远程主机(10.64.1.129)需求：

1. 假设远程主机打开了ssh端口2. 启动了Postgresql，且监听端口为默认的54323. 远程主机的postgresql DB只允许localhost访问

本地主机(10.64.71.6)需求：

1. 安装了pgcli2. 启动命令ssh -qtN -L 10.64.71.6:5432:localhost:5432 10.64.1.129

[ 其中 localhost:5432 是指远程主机10.64.1.129上的5432和127.0.0.1的IP/host ]
在本地主机(10.64.71.6)上执行pgcli访问远程主机(10.64.1.129)的pg DB命令：

pgcli postgres://dtasuser:123123@10.64.71.6:5432/dtasdb

关于SSH -L本地转发

SSH服务器和应用服务器在一起，就是本地就是本地转发
-L [bind_address:]port:host:hostport
(man ssh)This works by allocating a socket to Listen to port on the local sIDe,optionally bound to the specifIEd bind_address. Whenever a connection is made to this port,the connection is forwarded over the secure channel,and a connection is made to host port hostport from the remote machine. Port forwardings can also be specifIEd in the configuration file. IPv6 addresses can be specifIEd by enclosing the address in square brackets. Only the superuser can forward privileged ports. By default,the local port is bound in accordance with the GatewayPorts setting. However,an explicit bind_address may be used to bind the connection to a specific address. The bind_address of “localhost” indicates that the Listening port be bound for local use only,while an empty address or ‘*’ indicates that the port should be available from all interfaces.

PGCLI下载

总结

以上是内存溢出为你收集整理的pgcli通过SSH本地转发连接远程服务器上的PostgreSQL DB全部内容，希望文章能够帮你解决pgcli通过SSH本地转发连接远程服务器上的PostgreSQL DB所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。