当我创建一个新用户,但它不能登录数据库
postgres@Aspire:/home/XXX$ createuser dev
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) y
然后创建一个数据库:
postgres@Aspire:/home/XXX$ createdb -O dev test_development
之后,我try 登录psql -U dev -W test_development
,但出现错误:
psql: FATAL: Peer authentication failed for user "dev"
我试图解决这个问题,但失败了.