[Bucardo-general] Moving bucardo server to new datacenter
rossj at cargotel.com
Sat Aug 1 18:02:04 UTC 2020
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.
rossj at cargotel.com
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 Ross
> rossj at cargotel.com
> 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
>> Sent from my iPad
>>> On 31 Jul 2020, at 07:16, David Christensen <david at endpoint.com> 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.
>>> David Christensen
>>> Senior Software and Database Engineer
>>> End Point Corporation
>>> david at endpoint.com
>>>> On Jul 30, 2020, at 2:52 PM, Jeff Ross <rossj at cargotel.com> wrote:
>>>> Is there an easy way to move the primary bucardo server to a new
>>>> datacenter without dropping and re-creating the replica?
>>>> Jeff Ross
>>>> rossj at cargotel.com
>>>> 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
>>>> Bucardo-general at bucardo.org
>>> Bucardo-general mailing list
>>> Bucardo-general at bucardo.org
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.
More information about the Bucardo-general