Re: Slony for upgrades

Jeff Frost wrote:
> 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!

Thanks, changed to seconds. I thought someone told me <5 minutes a
while ago but I might have been mistaken.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +