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
<[email protected]> 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
>
> [[email protected]](mailto:[email protected])
>
> From: Roland Che
> Sent: Friday, April 29, 2022 7:01 AM
> To: [email protected]
> 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.
_______________________________________________
Bucardo-general mailing list
[email protected]
https://bucardo.org/mailman/listinfo/bucardo-general
