[Bucardo-general] Upgrade to PostgreSQL 13

[Andreas Wahler]

Hi all,

just 2 short questions:

1. During Postgres migration from 9.3 -> 13.0 via pg_dump we'll also 
jump from bucardo 5.4 to 5.6. Could we keep the table structure, 
triggers etc. during the upgrade or do we have to make a fresh bucardo 
install?

2. Log level "normal" doesn't show us any activity within the bucardo 
log; on "verbose" it is very talkative. At bucardo 5.4 we ran on 
"normal" and got log entries each time, a table content was changed. Is 
there an adequate option at bucardo 5.6?

Common information:

We've already tested a mixed operation with bucardo 5.6 with PG 9.3 on 
one hand and PG 13 on the other side without any issues.Also 
installation and setup of 5.6 upon a fresh database server was very easy 
and successful; many thanks at this point!

KR
Andreas


Andreas Wahler
Wamtek Information Systems GmbH
Bahnstrasse 17a
61381 Friedrichsdorf
andreas.wahler at wamtek.net
Telefon: +49 6172 28 5 11 0 <tel:+496172285110>
http://www.wamtek.net
Geschäftsführer: Andreas Wahler, Kai Emmerling
Amtsgericht Bad Homburg HRB 9479


Am 10.10.2020 um 15:16 schrieb Andreas Wahler:
>
> Hi David,
>
> we're are using Bucardo for 8 years in multi-master configuration. 
> Actually, we're thinking of giving pg_upgrade a try but be ready for a 
> complete re-install using pg_dump. But first we've to do some 
> preparation including a complete setup with staging server - we'll see.
>
> If it is interesting for other reading this mailing list I will keep 
> you updated.
>
> Thanks and all the best,
> Andreas
>
>
> Andreas Wahler
> Wamtek Information Systems GmbH
>
> Am 09.10.2020 um 15:18 schrieb David Christensen:
>>> On Oct 8, 2020, at 4:20 PM, Andreas Wahler<andreas.wahler at wamtek.net>  wrote:
>>>
>>> Hi all,
>>>
>>> we'd like to upgrade our 9.3 postgres server up to version 13.0. Should we expect any problems with bucardo?
>>>
>>> Thank you in advance,
>>> Andreas
>> Hi Andreas,
>>
>> There are no known issues for that approach, assuming you have Primary Keys on all tables or are ok setting up fullcopy syncs for the ones that don’t.
>>
>> Just out of curiosity, are you already using Bucardo, and have you looked at other options for database upgrades (like pg_upgrade)?  Not to say this is the wrong tool, but if it’s a self-hosted -> self-hosted upgrade I’d definitely look at pg_upgrade first unless there were strict uptime requirements that even a few minutes of downtime are unacceptable.
>>
>> Best,
>>
>> David
>> --
>> David Christensen
>> Senior Software and Database Engineer
>> End Point Corporation
>> david at endpoint.com
>> 785-727-1171
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20201113/f8346f97/attachment.htm>