Skip to main content

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 @Meera

Thanks for the fast respond. I'll try to set it up tomorrow and report back if everything worked.

Kind Regards

Thomas


Hello @Meera

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 @Punit Koujalgi

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