[Bucardo-general] ADVICE PLEASE

[Roland Che]

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
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/20220429/e5d23068/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 24851 bytes
Desc: image001.png
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20220429/e5d23068/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image615486.png
Type: image/png
Size: 2582 bytes
Desc: image615486.png
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20220429/e5d23068/attachment-0003.png>