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
