我创建了一个这样的用户:
原文链接:https://www.f2er.com/postgresql/192731.htmlcreate user blog with password 'blog';
然后我把它作为数据库的所有者:
alter database blog_development owner to blog;
然后我试图登录,它没有工作:
$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,但似乎没有改变任何东西.