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 <[email protected]> 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 > [email protected] > 785-727-1171 >
_______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
