PostgreSQL学习第六篇--psql常用连接数据库的方法

最新推荐文章于 2025-06-12 09:59:04 发布

最新推荐文章于 2025-06-12 09:59:04 发布 · 1.5w 阅读

文章标签：

#PostgreSQL学习第六篇--psq

Oracle DBA的PostgreSQL之路同时被 2 个专栏收录

84 篇文章

订阅专栏

postgresql

60 篇文章

订阅专栏

本文介绍了使用psql客户端连接PostgreSQL数据库的过程，包括解决连接失败的问题、配置listen_addresses、启动和停止服务、修改pg_hba.conf文件等内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

psql -h <hostname or ip> -p <port> [dbname] [username]
-h 指定要连接数据库所在的主机名或者IP地址
-p 指定连接的数据库端口，最后两个参数是数据库名和用户名。
示例：
[postgres@single ~]$ psql -h 186.168.100.13 -p 5432 testdb postgres
psql: could not connect to server: Connection refused
        Is the server running on host "186.168.100.13" and accepting
        TCP/IP connections on port 5432?
[postgres@single ~]$ psql -h localhost -p 5432 testdb postgres
psql (9.6.1)
Type "help" for help.

[postgres@single pgdata]$ vi postgresql.conf

listen_addresses = '*'

[postgres@single pgdata]$ psql stop
psql: FATAL:  database "stop" does not exist
[postgres@single pgdata]$ pg_ctl stop
waiting for server to shut down.... done
server stopped
[postgres@single pgdata]$ pg_ctl start
server starting
[postgres@single pgdata]$ LOG:  database system was shut down at 2016-11-17 22:08:59 CST
LOG:  MultiXact member wraparound protections are now enabled
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started

 [postgres@single pgdata]$ psql -h 186.168.100.13 -p 5432 testdb postgres
FATAL:  no pg_hba.conf entry for host "186.168.100.13", user "postgres", database "testdb"
psql: FATAL:  no pg_hba.conf entry for host "186.168.100.13", user "postgres", database "testdb"

[postgres@single pgdata]$ vi pg_hba.conf
# IPv4 local connections:
host    all             all              186.168.100.13/32       trust 

[postgres@single pgdata]$ pg_ctl stop
LOG:  received fast shutdown request
LOG:  aborting any active transactions
LOG:  autovacuum launcher shutting down
LOG:  shutting down
waiting for server to shut down....LOG:  database system is shut down
 done
server stopped
[postgres@single pgdata]$
[postgres@single pgdata]$ pg_ctl start
server starting
[postgres@single pgdata]$ LOG:  database system was shut down at 2016-11-17 22:16:14 CST
LOG:  MultiXact member wraparound protections are now enabled
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started

[postgres@single pgdata]$
[postgres@single pgdata]$ psql -h 186.168.100.13 -p 5432 testdb postgres
psql (9.6.1)
Type "help" for help.

testdb=#