■環境
Ubuntu Server 18.04.2
PostgreSQL 10
■発生したエラー
zen@redmine:~$ psql -d redmine -U dbuser -W Password for user dbuser: psql: FATAL: Peer authentication failed for user "dbuser"
■編集したファイル
/etc/postgresql/10/main/pg_hba.conf
★書き換え前
# "local" is for Unix domain socket connections only local all all peer
★書き換え後
# "local" is for Unix domain socket connections only local all all md5
■Postgresqlのサービス再起動
sudo service postgresql restart
■これで成功した!
zen@redmine:~$ psql -d redmine -U dbuser -W Password for user dbuser: psql (10.5 (Ubuntu 10.5-0ubuntu0.18.04)) Type "help" for help. redmine=>
■参考にしたURL