postgresql中ident认证与OS环境变量PGUSER的关系

最新推荐文章于 2024-06-12 08:00:00 发布

msdnchina

最新推荐文章于 2024-06-12 08:00:00 发布

阅读量734

点赞数 1

分类专栏： PostgreSQL 文章标签： pg ident 认证 postgres authentication

PostgreSQL 专栏收录该内容

214 篇文章 1 订阅

订阅专栏

[highgo475@abc global]$ env | grep PG
PGPORT=5899
PGUSER=highgo
PGHOME=/home/highgo475/highgo/database/4.7.5
PGDATA=/home/highgo475/highgo/database/4.7.5/data
[highgo475@abc global]$ cd
[highgo475@abc ~]$ vi .bash_profile 
[highgo475@abc ~]$ 
[highgo475@abc ~]$ 


[highgo475@abc data]$ psql
日志:  00000: 所提供的用户名(highgo)和被认证的用户名(highgo475) 不匹配
致命错误:  28000: 对用户"highgo"的对等认证失败
详细信息:  与Connection相匹配的文件行位于 pg_hba.conf 80: "local   all             all                                  ident"
psql: 致命错误:  28000: 对用户"highgo"的对等认证失败
[highgo475@abc data]$ 
[highgo475@abc data]$ 
[highgo475@abc data]$ 




[highgo475@abc ~]$ exit
logout
[root@abc ~]# su - highgo475
[highgo475@abc ~]$ 
[highgo475@abc ~]$ 
[highgo475@abc ~]$ strace -fvttTyy -s 2560 -o /tmp/strace_psql_ident_20181211_2^Cxt psql
[highgo475@abc ~]$ env | grep PG
PGPORT=5899
PGUSER=lei
PGHOME=/home/highgo475/highgo/database/4.7.5
PGDATA=/home/highgo475/highgo/database/4.7.5/data
[highgo475@abc ~]$ vi .bash_profile ^C
[highgo475@abc ~]$ ^C
[highgo475@abc ~]$ strace -fvttTyy -s 2560 -o /tmp/strace_psql_ident_20181211_2.txt psql
日志:  00000: 所提供的用户名(lei)和被认证的用户名(highgo475) 不匹配
致命错误:  28000: 对用户"lei"的对等认证失败
详细信息:  与Connection相匹配的文件行位于 pg_hba.conf 80: "local   all             all                                  ident"
psql: 致命错误:  28000: 对用户"lei"的对等认证失败
[highgo475@abc ~]$ 




[highgo475@abc ~]$ env | grep PG
PGPORT=5899
PGHOME=/home/highgo475/highgo/database/4.7.5
PGDATA=/home/highgo475/highgo/database/4.7.5/data
[highgo475@abc ~]$ strace -fvttTyy -s 2560 -o /tmp/strace_psql_ident_20181211_3.txt psql
致命错误:  28000: 角色 "highgo475" 不存在
psql: 致命错误:  28000: 角色 "highgo475" 不存在
[highgo475@abc ~]$