<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#ffffff">
<p><font face="Helvetica, Arial, sans-serif">Hi all,</font></p>
<p><font face="Helvetica, Arial, sans-serif">just 2 short questions:
<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">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?</font></p>
<p><font face="Helvetica, Arial, sans-serif">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?</font></p>
<p><font face="Helvetica, Arial, sans-serif">Common information:<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">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!</font></p>
<p><font face="Helvetica, Arial, sans-serif">KR<br>
Andreas</font></p>
<br>
<div class="moz-signature">
Andreas Wahler<br>
Wamtek Information Systems GmbH<br>
Bahnstrasse 17a<br>
61381 Friedrichsdorf<br>
<a class="moz-txt-link-abbreviated" href="mailto:andreas.wahler@wamtek.net">andreas.wahler@wamtek.net</a><br>
Telefon: <a href="tel:+496172285110">+49 6172 28 5 11 0</a><br>
<a class="moz-txt-link-freetext" href="http://www.wamtek.net">http://www.wamtek.net</a><br>
Geschäftsführer: Andreas Wahler, Kai Emmerling<br>
Amtsgericht Bad Homburg HRB 9479<br>
<br>
<br>
</div>
<div class="moz-cite-prefix">Am 10.10.2020 um 15:16 schrieb Andreas
Wahler:<br>
</div>
<blockquote type="cite"
cite="mid:7e49526c-552e-3be4-042d-522da032489d@wamtek.net">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<p><font face="Helvetica, Arial, sans-serif">Hi David,</font></p>
<p><font face="Helvetica, Arial, sans-serif">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. <br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">If it is interesting
for other reading this mailing list I will keep you updated.</font></p>
<p><font face="Helvetica, Arial, sans-serif">Thanks and all the
best,<br>
Andreas<br>
</font></p>
<div class="moz-signature"><br>
Andreas Wahler <br>
Wamtek Information Systems GmbH<br>
<br>
</div>
<div class="moz-cite-prefix">Am 09.10.2020 um 15:18 schrieb David
Christensen:<br>
</div>
<blockquote type="cite"
cite="mid:459F1F86-A239-4D2F-9AB8-516FADAA2E62@endpoint.com">
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">On Oct 8, 2020, at 4:20 PM, Andreas Wahler <a class="moz-txt-link-rfc2396E" href="mailto:andreas.wahler@wamtek.net" moz-do-not-send="true"><andreas.wahler@wamtek.net></a> 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
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">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
<a class="moz-txt-link-abbreviated" href="mailto:david@endpoint.com" moz-do-not-send="true">david@endpoint.com</a>
785-727-1171
</pre>
</blockquote>
</blockquote>
</body>
</html>