Authentication Problem When Connecting to PostgreSQL

Product version: 10.6

Last modified: 1 February 2022

Problem

The connection to PostgreSQL database is rejected even with correct credentials.

Background

PostgreSQL uses different internal authentication methods. One of the most common reasons for rejected authentication is if the authentication method is set to reject, which denies the user connection regardless of credentials.

Solution

To change the authentication method, do the following:

  1. Open the pg_hba.conf file located in the external database installation folder.

  2. Change the method for your connection from reject to the respective method for your version of PostgreSQL.

  3. Restart external database service.

  4. Restart NAKIVO Backup & Replication.

Note
It is not advised to change authentication method to trust due to security considerations.