pg设置本机psql连接是否需要密码

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

原创最新推荐文章于 2025-06-12 09:59:04 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

Highgo DB 同时被 2 个专栏收录

171 篇文章

订阅专栏

PostgreSQL

162 篇文章

订阅专栏

本文介绍如何通过修改PostgreSQL的pg_hba.conf文件实现连接认证方式从MD5到信任的更改，并展示了这一过程中涉及的数据库重启、连接测试等关键步骤。

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

[postgres9.6@db data]$ vi pg_hba.conf

# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5

[postgres9.6@db data]$ pg_ctl stop
waiting for server to shut down.... done
server stopped
[postgres9.6@db data]$ pg_ctl start
server starting
[postgres9.6@db data]$ LOG: redirecting log output to logging collector process
HINT: Future log output will appear in directory "pg_log".

[postgres9.6@db data]$ psql -d test -U postgres9.6
Password for user postgres9.6: -----此时提示需要输入密码
Null display is "NULL".
Pager is always used.
Timing is on.
psql (9.6.1)
Type "help" for help.

postgres9.6@[local]:5432 test# \q

[postgres9.6@db data]$ vi pg_hba.conf
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
[postgres9.6@db data]$ pg_ctl stop
waiting for server to shut down.... done
server stopped
[postgres9.6@db data]$ pg_ctl start
server starting
[postgres9.6@db data]$ LOG: redirecting log output to logging collector process
HINT: Future log output will appear in directory "pg_log".

[postgres9.6@db data]$ psql -d test -U postgres9.6
Null display is "NULL".
Pager is always used.
Timing is on.
psql (9.6.1)
Type "help" for help.

postgres9.6@[local]:5432 test#
postgres9.6@[local]:5432 test# \dt
List of relations
Schema | Name | Type | Owner
--------+-------+-------+-------------
public | test | table | postgres9.6
public | testa | table | test
(2 rows)

postgres9.6@[local]:5432 test#