postgresql10 createdb

postgres@Tahr:/home/tahr/mysite$ createdb -E utf8 -U blog blog
createdb: could not connect to database template1: FATAL:  Peer authentication failed for user "blog"

解决方法:

修改

local   all             all                                     peer

为

local   all             all                                     trust


sudo /etc/init.d/postgresql reload

 

posted @ 2019-09-17 14:00  kissrule  阅读(302)  评论(0)  编辑  收藏  举报