-
Title
Postgresql Database found, but failed to backup Database -
Description
Backups Failing on Postgresql Database
Database found, but failed to backup Database
Job Message 2012/05/23 21:53:44 244 Data Plugin ULB-GOV-IN-DB-NEW Launching backup command : '/usr/bin/pg_dump --format=plain --schema-only "bdrjk" '
Error 2012/05/23 21:53:44 244 Data Plugin ULB-GOV-IN-DB-NEW Database found, but failed to backup Database 'bdrjk' .
Error 2012/05/23 21:53:44 244 Data Plugin ULB-GOV-IN-DB-NEW No data/items are saved in the media. -
Cause
The postgresql.conf by default no ip's are allowed to access the database when the backup servers ip is added the backups complete successfully.
-
Resolution
Pull tracefiles from the Postgresql Client and find the command that the plugin is passing to the database. Paste that command directly to the command line, if successful but still cannot run the job from the plugin then you know the access is being denied by ip.
The postgresql.conf by default no ip's are allowed to access the database when the backup servers ip is added the backups complete successfully.
-
Additional Information
Great Configuration help with Postgresql.
http://www.yolinux.com/TUTORIALS/LinuxTutorialPostgreSQL.html