Just a follow-up--everything went smooth as silk and bucardo replication
took no time at all to get synced back up again after moving the primary.
Thanks again!
Jeff
Jeff Ross
[email protected]
On 7/31/20 12:52 PM, Jeff Ross wrote:
Thank you David and Michelle!
The primary database that will be moved is currently streaming to the
new datacenter so the bucardo database is a part of that.
I will shut down bucardo on the current primary before failover and
restart it on the new primary in the new datacenter after promotion.
Jeff
Jeff Ross
[email protected]
On 7/30/20 5:58 PM, Michelle Sullivan wrote:
First hand experience of this.. server got physically relocated to
another country... I manually updated the database table for the new
IP address.. so long as the hostname doesn’t change in Bucardo.. it
will just keep replicating and catchup when it’s in its new
position. My advice though shutdown bucardo whilst the move happens
unless you have other DBs that are also replicated (I did so didn’t
shut it down) because it will keep shutting down and restarting if
it’s a master.
Michelle Sullivan
http://www.mhix.org/
Sent from my iPad
On 31 Jul 2020, at 07:16, David Christensen <[email protected]> wrote:
Hi Jeff,
If you’re talking about the location where the Bucardo daemon runs,
you can just dump the “bucardo” database, move that to the new
location, and just start the daemon up on that location after
installing Bucardo on that machine.
You will need to make sure that anything you’ve added for connection
details (bucardo connection config, .pgpass/.pg_service, etc) makes
the trip as well, but otherwise it should be pretty straightforward.
Best,
David
--
David Christensen
Senior Software and Database Engineer
End Point Corporation
[email protected]
785-727-1171
On Jul 30, 2020, at 2:52 PM, Jeff Ross <[email protected]> wrote:
Hi,
Is there an easy way to move the primary bucardo server to a new
datacenter without dropping and re-creating the replica?
Jeff
--
Jeff Ross
[email protected]
--
The contents of this e-mail and any attachments are intended solely
for the use of the named addressee(s) and may contain confidential
and/or privileged information. Any unauthorized use, copying,
disclosure, or distribution of the contents of this e-mail is
strictly prohibited by the sender and may be unlawful. If you are
not the intended recipient, please notify the sender immediately
and delete this e-mail.
_______________________________________________
Bucardo-general mailing list
[email protected]
https://bucardo.org/mailman/listinfo/bucardo-general
_______________________________________________
Bucardo-general mailing list
[email protected]
https://bucardo.org/mailman/listinfo/bucardo-general
--
The contents of this e-mail and any attachments are intended solely for the
use of the named addressee(s) and may contain confidential and/or
privileged information. Any unauthorized use, copying, disclosure, or
distribution of the contents of this e-mail is strictly prohibited by the
sender and may be unlawful. If you are not the intended recipient, please
notify the sender immediately and delete this e-mail.
_______________________________________________
Bucardo-general mailing list
[email protected]
https://bucardo.org/mailman/listinfo/bucardo-general
