| From: | Jeff Frost <jeff(at)frostconsultingllc(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org> |
| Subject: | Re: Slony for upgrades |
| Date: | 2007-10-16 05:11:53 |
| Message-ID: | Pine.LNX.4.64.0710152208320.4620@discord.home.frostconsultingllc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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 <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-10-16 05:38:09 | Re: Slony for upgrades |
| Previous Message | Hiroshi Saito | 2007-10-16 04:34:01 | correct reference external-projects.sgml |