Run su - postgres -c PSQL, and follow along in Listing 8.
运行su-postgres -cps ql,并执行清单8中的命令。
Check out some of the key features: Pervasive PSQL v11 Support.
来看看他们的一些主要特征:支持PSQL v11。
Clients such as PSQL and pgadmin also have the requisite capabilities.
诸如psql和pgadmin之类的客户机也具有这类必需的功能。
What happens if there is no PSQL client on the remote PostgreSQL server?
如果远程PostgreSQL服务器上不存在ps ql客户机,会发生什么?
It allows your PostgreSQL clients, such as PSQL, pgadmin, and even openoffice, to connect to the remote Postgres server with an SSH connection.
它允许您的PostgreSQL客户机,比如psql、pgadmin甚至openoffice,通过一个SSH连接与远程Postgres服务器建立联系。
What do you do when you need to use database clients because they can perform certain tasks that the PSQL client can't do as well, or can't do at all?
如果需要使用数据库客户机来执行psql客户机无法很好地执行或根本无法执行的任务,该怎么做?
On the client side, you can control the client's (PSQL) default behavior for using an encrypted session or not by defining the environment variable PGSSLMODE.
在客户机端,可以通过定义环境变量pgsslmode来控制客户机(psql)的默认行为:是否使用加密的会话。
On a remote host, 192.168.2.100, you connect into your local host's PostgreSQL server, which is already listening on port 5432: PSQL -h 192.168.2.64 -p 5432 -u postgres postgres.
在一个远程主机192.168.2.100上,您连接到您的本地主机的PostgreSQL服务器,后者已经在侦听端口5432:ps ql- h 192.168.2.64- p 5432- U postgres postgres。
On a remote host, 192.168.2.100, you connect into your local host's PostgreSQL server, which is already listening on port 5432: PSQL -h 192.168.2.64 -p 5432 -u postgres postgres.
在一个远程主机192.168.2.100上,您连接到您的本地主机的PostgreSQL服务器,后者已经在侦听端口5432:ps ql- h 192.168.2.64- p 5432- U postgres postgres。
应用推荐