PG配置.pgpass密码文件

PG配置.pgpass密码文件

一个用户的“~/.pgpass”文件能够包含在连接需要时使用的口令（并且其他情况不会指定口令）

#  格式
hostname:port:database:username:password

# 示例  
echo "*:*:*:*:1qaz@WSX" > ~/.pgpass
chmod 600  ~/.pgpass

# 默认情况下是需要输入密码的
[pg12@wcbpgcm1 data]$ psql
Password for user postgres: 
psql (12.9)
Type "help" for help.

postgres=# 

[pg12@wcbpgcm1 ~]$ cat >>  ~/.pgpass <<"EOF"
localhost:5432:postgres:postgres:wcb
EOF
[pg12@wcbpgcm1 data]$ chmod 600  ~/.pgpass
[pg12@wcbpgcm1 data]$ 
[pg12@wcbpgcm1 data]$ psql
psql (12.9)
Type "help" for help.

postgres=# 
[pg12@wcbpgcm1 data]$ psql -h localhost -d postgres -U postgres
psql (12.9)
Type "help" for help.

postgres=# 
[pg12@wcbpgcm1 ~]$ pwd
/home/pg12
[pg12@wcbpgcm1 ~]$ mv .pgpass .pgpass_bk
[pg12@wcbpgcm1 ~]$ psql
Password for user postgres: 
[pg12@wcbpgcm1 ~]$ export PGPASSFILE=~/.pgpass_bk
[pg12@wcbpgcm1 ~]$ psql
psql (12.9)
Type "help" for help.

postgres=# \q