<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">Hello Jon,</font></p>
<p><font face="Helvetica, Arial, sans-serif">thank you for your
reply; everything went well </font><font face="Helvetica,
Arial, sans-serif"><font face="Helvetica, Arial, sans-serif">during
our migration</font>. We saved the PG9 databases using pg_dump
from PG13 and restored them accordingly within the new system.
Afterwards a 'bucardo upgrade' did the job.</font></p>
<p><font face="Helvetica, Arial, sans-serif">The verbose level is
maybe a matter of taste, but no problem :)</font></p>
<p><font face="Helvetica, Arial, sans-serif">Again, thank you for
your help and I wish you all the best<br>
Andreas</font><br>
</p>
<div class="moz-signature"><br>
</div>
<div class="moz-cite-prefix">Am 03.12.2020 um 03:42 schrieb Jon
Jensen:<br>
</div>
<blockquote type="cite"
cite="mid:468oorp4-9q1r-2rr-q660-n444sn759357@raqcbvag.pbz">Hello,
Andreas.
<br>
<br>
On Fri, 13 Nov 2020, Andreas Wahler wrote:
<br>
<br>
<blockquote type="cite">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?
<br>
</blockquote>
<br>
I believe you can keep the bucardo schema as is, but of course you
should test that on a copy of your database.
<br>
<br>
<blockquote type="cite">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?
<br>
</blockquote>
<br>
I wonder if the changes made in this commit are the cause of that
difference:
<br>
<br>
<a class="moz-txt-link-freetext" href="https://github.com/bucardo/bucardo/commit/371556c93c0934cf9cd60b3cf6e8205566da8192">https://github.com/bucardo/bucardo/commit/371556c93c0934cf9cd60b3cf6e8205566da8192</a>
<br>
<br>
Greg Sabino Mullane evidently felt that the normal logs should be
quieter.
<br>
<br>
Personally I would probably just use verbose mode and tolerate the
extra noise, and rotate & compress the logs more frequently if
needed.
<br>
<br>
<blockquote type="cite">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!
<br>
</blockquote>
<br>
That is great to hear!
<br>
<br>
Jon
<br>
<br>
<br>
</blockquote>
</body>
</html>