[Bucardo-general] Moving bucardo server to new datacenter

[Michelle Sullivan]

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