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
[email protected]
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<[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
