Skip site navigation (1) Skip section navigation (2)

Re: Slony for upgrades

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
Subject: Re: Slony for upgrades
Date: 2007-10-16 05:38:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docs
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>

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

In response to


pgsql-docs by date

Next:From: Magnus HaganderDate: 2007-10-16 12:14:50
Subject: Re: correct reference external-projects.sgml
Previous:From: Jeff FrostDate: 2007-10-16 05:11:53
Subject: Re: Slony for upgrades

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group