[Bucardo-general] Moving bucardo server to new datacenter

David Christensen david at endpoint.com
Fri Jul 31 19:33:02 UTC 2020


If you are changing connection info for one of the dbs as part of this you will have to update the dbh Bucardo as well. If it’s using dns and the name isn’t changing you are probably fine just stopping Bucardo on the one side and starting it on the other. 

Best,

David

Sent from my iPhone

> On Jul 31, 2020, at 1:52 PM, Jeff Ross <rossj at cargotel.com> 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
> 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
>> http://www.mhix.org/
>> 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.
>>> 
>>> Best,
>>> 
>>> David
>>> --
>>> David Christensen
>>> Senior Software and Database Engineer
>>> End Point Corporation
>>> david at endpoint.com
>>> 785-727-1171
>>> 
>>> 
>>>> On Jul 30, 2020, at 2:52 PM, Jeff Ross <rossj at cargotel.com> 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
>>>> 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
>>>> https://bucardo.org/mailman/listinfo/bucardo-general
>>> _______________________________________________
>>> Bucardo-general mailing list
>>> Bucardo-general at bucardo.org
>>> 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.


More information about the Bucardo-general mailing list