In pg_hba.conf,thefirst matchcounts.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

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

重新登录

# psql -U xxx -d msolution.cn_development

psql (9.6.1)

Type "help" for help.

xxx=>