[Bucardo-general] ADVICE PLEASE

[Enrique P.]

Hi Roland,

Please check the following links (and/or the bucardo man page):

https://bucardo.org/Bucardo/operations/onetimecopy
https://bucardo.org/Bucardo/object_types/fullcopy
https://bucardo.org/Bucardo/object_types/pushdelta

If you just add a "standard" sync and do nothing else, the tables will be copied over based on triggers. That's why existing values will not be copied.

BR!
------- Original Message -------
On Friday, April 29th, 2022 at 3:17 PM, Roland Che via Bucardo-general <bucardo-general at bucardo.org> wrote:

> We want to use Bucardo as an upgrade solution so how will I go about promoting the standby
>
> To become a standalone so applications can then connect to the newer version?
>
> Roland Che​
>
> Senior Database Administrator II
>
> [Roland.Che at PAYROC.COM](mailto:Roland.Che at payroc.com)
>
> From: Roland Che
> Sent: Friday, April 29, 2022 7:01 AM
> To: bucardo-general at bucardo.org
> Subject: ADVICE PLEASE
>
> Hello Team,
>
> We are having an ubuntu 14.04 server with postgres 9.3 and we have issues upgrading the server so we want to use
>
> Bucardo to do a logical replication from postgres 9.3 to 13. I have done a test with Bucardo and I noticed existing data
>
> Was not replicated.
>
> My question is must I do an initial load like manually dump the existing data from the primary and restore on the standby node?
>
> And another concern is while copying the existing data and application is still connected , what happened to the new inserts coming in from application when
>
> The replication has not started ?
>
> Please advice on the process.
>
> [Text
>
> Description automatically generated]
>
> Regards
>
> Roland Che.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20220503/d6429a38/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 24851 bytes
Desc: not available
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20220503/d6429a38/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image615486.png
Type: image/png
Size: 2582 bytes
Desc: not available
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20220503/d6429a38/attachment-0003.png>