Hi David, Can you please help with my query that I have sent earlier.
Thanks in Advance, Arshi Shaikh On Thu, Dec 27, 2018 at 12:39 PM arshi shaikh <[email protected]> wrote: > Hi . > > Any update ? > > Thanks, > Arshi Shaikh > > On Tue, Dec 11, 2018, 5:34 PM arshi shaikh <[email protected]> wrote: > >> >> Hi David, >> >> Thanks a lot for your reply. Below is the scenario that we are trying. >> >> As explained earlier we have 3 node Multimaster cluster and bucardo is >> running on separate node. >> We would like to take the backup from one of the nodes so that in event >> when any of the node goes down we can do >> recover from the backup. >> >> Assume that backup is taken at 10:00AM from one of the cluster node and >> bucardo node. Backup is taken using pg_basebackup utility of Postgres. >> Consider node 3 goes down at 10:30AM and we want to recover it so that it >> can join the existing cluster and be in sync with >> other Master nodes. >> >> We tried following steps to achieve this >> >> 1. Performed restore on node3 from the backup taken at 10:00AM. >> 2. After restore was completed node3 was able to join the cluster. >> However Transaction that happend between 10:00AM to 10:30AM >> where missing from this node. Also bucardo did not recognizes that node3 >> is not in sync. >> >> We would like to know that if there are any additional steps need to >> perform to bring node3 in sync. Also let us know if we are doing anything >> wrong. >> >> Any help or suggestion are appreciated. >> >> Thanks in Advance, >> Arshi Shaikh >> >> >> On Thu, Nov 29, 2018 at 11:24 PM David Christensen <[email protected]> >> wrote: >> >>> > Hi , >>> > >>> > Can some one please point me to the document or guide me steps by >>> which I can take the backup of postgres9.6 running bucado cluster. >>> > >>> > I have 3 node. Node1 is running bucardo server and other 2 are data >>> node. >>> > I want to know exact steps by which I can take backup of bucardo >>> cluster and prerequisites that I have to check before triggering the backup. >>> > Also steps to restore the backup on failed node and joining back in >>> cluster or adding new node in cluster. >>> > Any Help is appreciated .. >>> >>> Hi Arshi, >>> >>> There shouldn’t really be any specific trick to this; you’d just backup >>> the database as normal, making sure to also backup your “bucardo” database >>> if that runs on a separate database cluster. “pg_dump”, “pg_backrest”, >>> etc should just work as normal to save the state of the Bucardo database. >>> >>> HTH, >>> >>> David >>> -- >>> David Christensen >>> End Point Corporation >>> [email protected] >>> 785-727-1171 >>> >>> >>> >>>
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
