[Bucardo-general] Upgrade to PostgreSQL 13

Andreas Wahler andreas.wahler at wamtek.net
Fri Nov 13 10:07:10 UTC 2020

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 

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!


Andreas Wahler
Wamtek Information Systems GmbH
Bahnstrasse 17a
61381 Friedrichsdorf
andreas.wahler at wamtek.net
Telefon: +49 6172 28 5 11 0 <tel:+496172285110>
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>

More information about the Bucardo-general mailing list