PostgreSQL学习第五篇--本机psql设置需要/不需要密码

前端之家收集整理的这篇文章主要介绍了PostgreSQL学习第五篇--本机psql设置需要/不需要密码前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
[postgres@single ~]$ psql
psql (9.6.1)
Type "help" for help.

postgres=#
无需输入密码,可以修改pg_hba.conf文件来要求输入密码。
设置完成后需要重启之后生效。

以下为设置不需要密码的情况:

[postgres@single pgdata]$ 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
"pg_hba.conf" 93L,4466C written                                                                                                                                                                                         
[postgres@single pgdata]$ psql
Password:
psql: fe_sendauth: no password supplied
[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]$ pg_ctl start
server starting
[postgres@single pgdata]$ LOG:  database system was shut down at 2016-11-17 16:54:37 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
psql (9.6.1)
Type "help" for help.

postgres=#  
原文链接:https://www.f2er.com/postgresql/194243.html

猜你在找的Postgre SQL相关文章