我创建了这样一个用户:
create user blog with password 'blog';
然后我让它成为一个数据库的所有者:
alter database blog_development owner to blog;
然后我try 登录,但没有成功:
$ psql -d blog_development -U blog -W
Password for user blog:
psql: FATAL: Ident authentication failed for user "blog"
知道为什么吗?
我试过的一件事是编辑pg_hba.conf
76 # Database administrative login by UNIX sockets
77 local all postgres ident
78
79 # TYPE DATABASE USER CIDR-ADDRESS METHOD
80
81 # "local" is for Unix domain socket connections only
82 local all all ident
83 # IPv4 local connections:
84 host all all 127.0.0.1/32 md5
85 host blog_development blog 127.0.0.1/32 md5
86 # IPv6 local connections:
87 host all all ::1/128 md5
第85行是我添加的.在那之后,我重新启动了PostgreSQL,但它似乎没有改变任何事情.