Unable to backup PgSQL database
OpManager build 12100.
Running the backup script as advertised here https://support.zoho.com/portal/manageengine/helpcenter/articles/opmanager-backup-and-restore-for-build-9450-and-above but I get a
failure:
root@opmanager:/opt/ManageEngine/OpManager/bin/backup# sh BackupDB.sh -mode all -targetdb pgsql -destination /root/
file:/opt/ManageEngine/OpManager/conf/OpManager/ui.properties
Please wait ! Backup DB started .....
/ 29 out of 2521 tables completed.
jdbc.BackupException: Error writing data to file.
at jdbc.BackupDB.dumpDataToFile(BackupDB.java:179)
at jdbc.AbstractBackupDB.backupDB(AbstractBackupDB.java:109)
at jdbc.AbstractBackupDB.doBackup(AbstractBackupDB.java:531)
at jdbc.BackUpImpl.backupDB(BackUpImpl.java:83)
at jdbc.BackUpImpl.main(BackUpImpl.java:234)
Caused by: java.util.concurrent.ExecutionException: java.lang.Exception: Error while dumping data for table(s) -t BatchStartID : pg_dump: too many command-line arguments (first is "OpManagerDB")
Try "pg_dump --help" for more information.
at java.util.concurrent.FutureTask.report(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at jdbc.BackupDB.dumpDataToFile(BackupDB.java:176)
... 4 more
Caused by: java.lang.Exception: Error while dumping data for table(s) -t BatchStartID : pg_dump: too many command-line arguments (first is "OpManagerDB")
Try "pg_dump --help" for more information.
at jdbc.BackupDB$BackupDataThread.dumpDataUsingPgSqlDump(BackupDB.java:444)
at jdbc.BackupDB$BackupDataThread.dumpData(BackupDB.java:280)
at jdbc.BackupDB$BackupDataThread.call(BackupDB.java:242)
at jdbc.BackupDB$BackupDataThread.call(BackupDB.java:213)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
I changed the default database password as per this procedure https://support.zoho.com/portal/manageengine/helpcenter/articles/how-do-i-set-a-password-for-my-opmanager-pgsql-database-4-6-2014
Thanks,
Marco
Running the backup script as advertised here https://support.zoho.com/portal/manageengine/helpcenter/articles/opmanager-backup-and-restore-for-build-9450-and-above but I get a
failure:
root@opmanager:/opt/ManageEngine/OpManager/bin/backup# sh BackupDB.sh -mode all -targetdb pgsql -destination /root/
file:/opt/ManageEngine/OpManager/conf/OpManager/ui.properties
Please wait ! Backup DB started .....
/ 29 out of 2521 tables completed.
jdbc.BackupException: Error writing data to file.
at jdbc.BackupDB.dumpDataToFile(BackupDB.java:179)
at jdbc.AbstractBackupDB.backupDB(AbstractBackupDB.java:109)
at jdbc.AbstractBackupDB.doBackup(AbstractBackupDB.java:531)
at jdbc.BackUpImpl.backupDB(BackUpImpl.java:83)
at jdbc.BackUpImpl.main(BackUpImpl.java:234)
Caused by: java.util.concurrent.ExecutionException: java.lang.Exception: Error while dumping data for table(s) -t BatchStartID : pg_dump: too many command-line arguments (first is "OpManagerDB")
Try "pg_dump --help" for more information.
at java.util.concurrent.FutureTask.report(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at jdbc.BackupDB.dumpDataToFile(BackupDB.java:176)
... 4 more
Caused by: java.lang.Exception: Error while dumping data for table(s) -t BatchStartID : pg_dump: too many command-line arguments (first is "OpManagerDB")
Try "pg_dump --help" for more information.
at jdbc.BackupDB$BackupDataThread.dumpDataUsingPgSqlDump(BackupDB.java:444)
at jdbc.BackupDB$BackupDataThread.dumpData(BackupDB.java:280)
at jdbc.BackupDB$BackupDataThread.call(BackupDB.java:242)
at jdbc.BackupDB$BackupDataThread.call(BackupDB.java:213)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
I changed the default database password as per this procedure https://support.zoho.com/portal/manageengine/helpcenter/articles/how-do-i-set-a-password-for-my-opmanager-pgsql-database-4-6-2014
Thanks,
Marco