[Bucardo-general] Use case scenarios

Błażej Cegiełka blazej.cegielka at gmail.com
Tue May 7 15:42:13 UTC 2013


Hi all,

I would like to ask you guys what is/should be proper procedure for such 
scenarios:
* restoring data from snapshots
* bucardo MCP server/db has broken

My thoughts:
#1 - restoring:
* snapshots can be done on all nodes independently, and restore can be 
from just one (all nodes should be same)
* snapshots can be simple pg_dumped sql file
* before restore:
   ** bucardo MCP go down
   ** bucardo db is dropped
   ** bucardo install (to create fresh bucardo db)
   ** all nodes get restored from one choosen sql dump
   ** bucardo is configured with earlier configuration & started to 
handle new data changes.

#2 - bucardo server/db got has broken - well with such steps in 
restoring scenario, it will work also in this case.

Your comments?

Błażej


More information about the Bucardo-general mailing list