PostGreSQL APM installed on a new client and configured, when backup is run, it fails with the error:
Starting job 341 'full PostgreSQL test' (Phase 1, Instance 4) for UID 1
Initializing Backup job
Sent Plugin space left estimate of 36155 Mb
Launching backup command : '/usr/lib/postgresql/8.3/bin/pg_dumpall --globals-only '
Failed to backup Global Objects
No data/items are saved in the media.
Ran command from terminal and got error:
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
Correct user login details resolved the issue at hand
