Postgres psql: FATAL: Peer authentication failed for user "xxx"

In pg_hba.conf, the first match counts. Per documentation:

The first record with a matching connection type, client address, requested database, and user name is used to perform authentication. There is no "fall-through" or "backup": if one record is chosen and the authentication fails, subsequent records are not considered. If no record matches, access is denied.

编辑pg_hba.conf

# vim /var/lib/pgsql/9.6/data/pg_hba.conf

# PostgreSQL Client Authentication Configuration File

# ===================================================

#

# Refer to the "Client Authentication" section in the PostgreSQL

# documentation for a complete description of this file.  A short

# synopsis follows.

#

# This file controls: which hosts are allowed to connect, how clients

# are authenticated, which PostgreSQL user names they can use, which

# databases they can access.  Records take one of these forms:

#

# local      DATABASE  USER  METHOD  [OPTIONS]

# host       DATABASE  USER  ADDRESS  METHOD  [OPTIONS]

# hostssl    DATABASE  USER  ADDRESS  METHOD  [OPTIONS]

# hostnossl  DATABASE  USER  ADDRESS  METHOD  [OPTIONS]

local   all     xxx     trust

保存后reload配置文件

# /etc/init.d/postgresql-9.6 reload

重新登录

# psql -U xxx -d msolution.cn_development

psql (9.6.1)

Type "help" for help.

xxx=>