Hello,
One of our customers approached us with a PostgreSQL cluster (active-standby). How can we best set up the backup here, since Commvault cannot create a backup from standby.
Kind Regards
Thomas
Hi Thomas,
Please refer to this. https://documentation.commvault.com/2022e/expert/93037_back_up_from_standby_server.html
Regards,
Meera
Hello
Thanks for the fast respond. I'll try to set it up tomorrow and report back if everything worked.
Kind Regards
Thomas
Hello
We tried to set up the whole thing today. The backup can be started, but it does not continue and gets stuck in the "Running" status. I have attached a few logs here, maybe someone can help us.
Kind Regards
Thomas
Hello,
Going by logs, seems like replication is lagging behind a lot. Backup process only continues when Standby is up-to-date but here it seems we keep waiting for a long time for Standby to catch up.
29774 744e 06/14 12:48:34 5345052 PostgresStandbyBackup::WaitForLogTobeApplied() - Replay location 0/2C0000A0] log Location to be applied 2/4F000028]
29774 744e 06/14 12:48:34 5345052 PostgresStandbyBackup::WaitForLogTobeApplied() - Log NOT yet applied 2/4F000028]. Sleeping for 1 minute.
Can you please address the Replication to Standby and retry backup?
Thanks,
Punit
Hello
Thank you for pointing this out. Our database administrators were able to fix the problem now. The reason was that the two nodes were not in sync.
Kind Regards
Thomas
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.