Bitdog Honored Contributor.
Honored Contributor.
97 views

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?

 

Humbly,

 

Carl

“The world as we have created it is a process of our thinking. It cannot be changed without changing our thinking.”
― Albert Einstein
0 Likes
1 Reply
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Re: Embedded PostgreSQL backup fails

Hi Carl,

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:

1. shut down postgres (%TOPAZ_HOME%\bin\opr-pgctl.bat –stop)
2. Edit: %ovinstalldir%\databases\omidb\postgresql.conf
        and set "max_locks_per_transaction" to 6500 and uncomment it
 
Then try to do the backup again. (Optional) After that you can change the max_locks_per_transaction to 1000.
 
Best regards.
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.