[Bucardo-general] ADVICE PLEASE

[Roland Che]

Hello Team,
Thanks for the response and I will wish to ask some few questions.

We are planning to use Bucardo to upgrade our postgres 9.3 to version 13.
Can we set this up while the application is still connected to the source db? And what will happen with data coming
In while we are taking an initial data restore ? or will onecopy =2 solve this concern in a way that after the restore is
Completes, we start the sync and alter bucardo to add onecopy to the sync which will then copy everything together
With the data when we were doing the initial restore on the target?

Second question is are they some data types that the tool does not replicates data on columns with those data types?
And please is there a link to these data types as I check from the web site but could not see?

Lastly, after we allow replication to run for some days , how are we going to go about doing a cut-over to make the
Target to become a standalone? I did not see how to do a cutover on the website.

Please if I could get advise on these questions I will really appreciate.

Regards
Roland Che.



Roland Che
Senior Database Administrator II
Roland.Che at PAYROC.COM
From: Enrique P. <eps.lab at protonmail.com>
Sent: Tuesday, May 3, 2022 6:09 AM
To: Roland Che <Roland.Che at PAYROC.COM>
Cc: bucardo-general at bucardo.org
Subject: Re: [Bucardo-general] ADVICE PLEASE

Hi Roland,

Please check the following links (and/or the bucardo man page):
https://bucardo.org/Bucardo/operations/onetimecopy<https://bucardo.org/Bucardo/operations/onetimecopy>
https://bucardo.org/Bucardo/object_types/fullcopy<https://bucardo.org/Bucardo/object_types/fullcopy>
https://bucardo.org/Bucardo/object_types/pushdelta<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<mailto: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?

[cid:image002.png at 01D86091.B7FC2870]
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<mailto: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/20220505/ea3d2b4b/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 2582 bytes
Desc: image002.png
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20220505/ea3d2b4b/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 24851 bytes
Desc: image003.png
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20220505/ea3d2b4b/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image810538.png
Type: image/png
Size: 2582 bytes
Desc: image810538.png
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20220505/ea3d2b4b/attachment-0005.png>