On Mon, 15 Oct 2007, Bruce Momjian wrote:
Seems we didn't have any mention of Slony for upgrades in the migration
section, so I added it:
<para>
It is also possible to use <productname>Slony</> to create a slave
server with the updated version of <productname>PostgreSQL</>. The
slave can be on the same computer or a different computer. Once it
has synced up with the master server (running the older version of
<productname>PostgreSQL</>), you can switch masters and make the slave
the master and shut down the older database instance. Such a
switch-over results in only several minutes of downtime for an upgrade.
</para>
Bruce, do you think we should say several minutes of downtime? It's been my
experience that the downtime is usually measurable in seconds. I don't think
I've ever had a switchover take more than 1 minute.
Excellent catch and good work by the way!
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly