密码文件"/>
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
更多推荐
PG配置.pgpass密码文件
发布评论