[Jetbackup] dumping PostgreSQL may fail - FATAL: no pg_hba.conf entry for host "::1"

Symptoms

In some cases, Jetbackup might fail to backup PostgreSQL databases with the following error:

"[ERROR] Failed exporting database data. Database Handler Error: 
Failed export PostgreSQL database "cptechs_testing". Error: pg_dump: [archiver (db)] connection to database "cptechs_testing" failed: 
FATAL: no pg_hba.conf entry for host "::1", user "postgres", database "cptechs_testing", SSL off"

Description 

Jetbackup is currently reviewing an issue in which certain modifications to the PostgreSQL configuration file are preventing the successful dump of databases. This seems to be due to the "samerole" database flag for IPv6 ::1 entry in the configuration file: /var/lib/pgsql/data/pg_hba.conf

We will monitor this further and will update this article when a resolution is implemented.

Workaround

Edit the file /var/lib/pgsql/data/pg_hba.conf and add the following value to the bottom of the file:

host all all ::1/128 md5

When this is added to the configuration file, use the following commands to restart the PostgreSQL service, and then the Jetbackup service.

service postgresql restart

service jetbackup5d restart