-
Title
Can't backup Database PostGreSQL -
Description
PostGreSQL APM installed on new client and configured, when backup is run it fasils with the error:
Information 2012/03/09 11:50:23 341 Schedule PALLAS Starting phase 1 on srvcolt01
Job Message 2012/03/09 11:50:23 341 Jobs PALLAS Starting job 341 'full postgreSQL test' (Phase 1 , Instance 4) for UID 1
Job Message 2012/03/09 11:50:24 341 Data Plugin srvcolt01 Initializing Backup job
Background 2012/03/09 11:50:35 341 Media srvcolt01 Sent Plugin space left estimate of 36155 Mb
Job Message 2012/03/09 11:50:35 341 Data Plugin srvcolt01 Launching backup command : '/usr/lib/postgresql/8.3/bin/pg_dumpall --globals-only '
Error 2012/03/09 11:50:35 341 Data Plugin srvcolt01 Failed to backup Global Objects
Error 2012/03/09 11:50:35 341 Data Plugin srvcolt01 No data/items are saved in the media.Ran command from terminal and got error:
root@srvc:/usr/lib/postgresql/8.3/bin# ./pg_dumpall --globals-only -U postgrespg_dumpall: could not connect to database "template1": FATAL: Ident authentication failed for user "postgres"root@srvco:/usr/lib/postgresql/8.3/bin# ./pg_dumpall --globals-only -U netvaultpg_dumpall: could not connect to database "template1": FATAL: Ident authentication failed for user "netvault" -
Cause
The problem was caused by using the incorrect user authentication using the following syntax at cmd line revealed the issue:
psql -d database_name -U postgres - W
-
Resolution
Correct user login details resolved the issue at hand