cancel
Showing results for 
Search instead for 
Did you mean: 

BART and failover

Level 3 Adventurer

BART and failover

Before I start digging into some scripting, I'm curious if anyone has designed anything to automatically switch which server BART is backing up if the master goes down and the standby becomes the master?

 

Best,
Larry

2 REPLIES
Highlighted
EDB Team Member

Re: BART and failover

Hi lgwapnitsky,

 

Using VIP In this case will be wise decision.

The VIP remains active on Master and moves on to the Slave in case of failover.

 

Hope this helps.

Level 2 Adventurer

Re: BART and failover

Maybe you can include a check on 'Database cluster state' of pg_controldata command in your backup script. 

bash-4.4$ pg_controldata -D /var/lib/postgresql/data/ | grep 'Database cluster state'
Database cluster state: in production
bash-4.4$

If it is under recovery then do nothing, otherwise performs the BART backup.

 

Then setup the backup script to all DB servers, primary and standby(s) with cronjob.