Embedded PostgreSQL backup fails
Trying to backup OMi 10.12 database using opr-pgctl.bat -backup e:\temp\08jun2019 --force -z
The backup runs over 18 hours then fails with no errors. Is there a log anywhere or can logging be turned?
― Albert Einstein
Re: Embedded PostgreSQL backup fails
Yes, under HPBSM/log you should find opr-pgctl.log, that should show more details about the error.
Also, did you do a vacuum of the DB before doing the backup? It is mentioned in the PostrgreSQL Maintenance documentation, it is a good practice when doing ambedded DB backups, it is mentioned when doing the backup for an upgrade: https://docs.microfocus.com/itom/Operations_Bridge_Manager:2018.11/Database/psql_dbase_maint_tuning
The vacuum commands are documented in the upgrade guide, in Choose the installation type select Upgrade from OMi 10.12 (latest IP) or 10.6x and in DB type select PostgreSQL (embedded DBMS): https://docs.microfocus.com/OMi/2018.11/OBM_Install_Upgrade/Content/OMi_install_upgr.htm
If there is any error message about max_locks_per_transaction, I would suggest to increase it to 6500: