<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<font size="1" face="Verdana">Hi </font><br>
<br>
<font size="1" face="Verdana">I am looking to do a near-zero
downtime(or minimal downtime upgrade) from postgresql 9.6.16 to
12.7, and have installed and configured bucardo and its database.</font><br>
<font size="1" face="Verdana">I am looking at high level steps and
options to use to replicate an entire DB (~2TB). Please advise if
the below sequence is correct and help with specifics.</font><br>
<br>
<br>
<font size="1" face="Verdana">1. Add source database to Bucardo and
add all tables and sequences</font><br>
<font size="1" face="Verdana">2. Do a snapshot-Clone of the source
DB and upgrade it to 12.7</font><br>
<font size="1" face="Verdana">4. Add the 12.7 DB to bucardo and add
all tables and sequences</font><br>
<font size="1" face="Verdana">5. Start bucardo</font><br>
<p><font size="1"><font face="Verdana">Let me know if the above
sequence is what you'd use to achieve this, and there wont be
any data lost during the time taken for snapshot-clone and
about an hour that is taken to do the upgrade(9 to 10, 10 to
11 and 11 to 12), and that</font></font></p>
<p><font size="1"><font face="Verdana">bucardo will figure out all
the differences and apply them on the 12.7 target. Also let me
know the options, parameters to use</font></font></p>
<p><font size="1"><font face="Verdana"><br>
</font></font></p>
<p><font size="1"><font face="Verdana">Thanks in advance</font></font><br>
</p>
</body>
</html>