[Bucardo-general] Upgrade to PostgreSQL 13

[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/20201010/28227e2e/attachment.htm>