Connections - Host Based Authentication - specify ssl remote connections

Information

Client authentication is controlled by a configuration file, which traditionally is named pg_hba.conf and is stored in the database cluster's data directory. Each record specifies a connection type, a client IP address range (if relevant for the connection type), a database name, a user name, and the authentication method to be used for connections matching these parameters. 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.

Solution

Remove any entries from the pg_hba.conf file that allows un restricted access. Examples:

host <database> <user> <cidr_notation> password [<auth_options>]
host <database> <user> <hostname|ip> <netmask> password [<auth_options>]

See Also

https://www.postgresql.org/docs/9.6/static/index.html

Item Details

Category: SYSTEM AND COMMUNICATIONS PROTECTION

References: 800-53|SC-8

Plugin: Unix

Control ID: 347cd5b02bb14a12100014cf599ac8da1442d7a64f94e778348c4f4439330ee2