error backing up postgre DB

cPanel, Industry leading hosting platform with world-class support.
Post Reply
ludolugo
Posts: 52
Joined: April 17th, 2020, 10:40 am

error backing up postgre DB

Post by ludolugo »

Hi,
I am getting this error qhen backing up the postgres databases

Code: Select all

ERROR] Failed exporting database data. Database Handler Error: Failed export PostgreSQL database "s4q_rental_system_staging". Error: pg_dump: [archiver (db)] connection to database "s4q_rental_system_staging" failed: FATAL:  no hay una línea en pg_hba.conf para «::1», usuario «postgres», base de datos «s4q_rental_system_staging», SSL inactivo


[18/Feb/2022 00:48:50 +0000] [PID 47497] 		- Database "s4q_test"

[18/Feb/2022 00:48:51 +0000] [PID 47497] [ERROR] Failed exporting database data. Database Handler Error: Failed export PostgreSQL database "s4q_test". Error: pg_dump: [archiver (db)] connection to database "s4q_test" failed: FATAL:  no hay una línea en pg_hba.conf para «::1», usuario «postgres», base de datos «s4q_test», SSL inactivo
JetAppsClark
Staff Member
Staff Member
Posts: 21
Joined: October 4th, 2017, 4:40 am

Re: error backing up postgre DB

Post by JetAppsClark »

Hello ludolugo,

This issue is generally caused by the "samerole" database flag for the IPv6 ::1 entry in the pg_hba.conf file, which can cause the above mentioned error during backup of a PostgreSQL database for accounts.

In pg_hba.conf:

Code: Select all

host samerole all  ::1/128      md5
We are aware of certain modifications to the pg_hba.conf file preventing JetBackup from dumping PostgreSQL databases, and currently have an open internal case to fix this issue. A fix for this will be implemented in a future JetBackup 5 version.

In the meantime, please consider adding the below instead with the help and confirmation of your server administrator.

Code: Select all

host all all  ::1/128      md5
You can review the PostgreSQL documentation for pg_hba.conf here: https://www.postgresql.org/docs/current ... -conf.html

Then, restart PostgreSQL and JetBackup using these commands.

Code: Select all

service postgresql restart
service jetbackup5d restart
Please feel free to open a helpdesk ticket with our 24/7 support team at [email protected] if you continue to encounter issues with PostgreSQL database backups and we would be happy to assist further.
Thank You,
Clark, JetApps Team
Post Reply