pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedSlony for upgrades
5+ messages / 3 participants
[nested] [flat]
* Slony for upgrades
@ 2007-10-16 02:50 Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 5+ messages in thread
From: Bruce Momjian @ 2007-10-16 02:50 UTC (permalink / raw)
To: pgsql-docs
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 Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Slony for upgrades
@ 2007-10-16 05:11 Jeff Frost <jeff@frostconsultingllc.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 5+ messages in thread
From: Jeff Frost @ 2007-10-16 05:11 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: 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@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Slony for upgrades
@ 2007-10-16 05:38 Bruce Momjian <bruce@momjian.us>
parent: Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 1 reply; 5+ messages in thread
From: Bruce Momjian @ 2007-10-16 05:38 UTC (permalink / raw)
To: Jeff Frost <jeff@frostconsultingllc.com>; +Cc: 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@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Slony for upgrades
@ 2007-10-16 18:21 Robert Treat <xzilla@users.sourceforge.net>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 5+ messages in thread
From: Robert Treat @ 2007-10-16 18:21 UTC (permalink / raw)
To: pgsql-docs; +Cc: Bruce Momjian <bruce@momjian.us>; Jeff Frost <jeff@frostconsultingllc.com>
On Tuesday 16 October 2007 01:38, Bruce Momjian wrote:
> 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.
I might question the strict reference to Slony here. AIUI you could do the
same thing with Bucardo and a couple of other replication solutions as well.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Slony for upgrades
@ 2007-10-16 19:44 Bruce Momjian <bruce@momjian.us>
parent: Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2007-10-16 19:44 UTC (permalink / raw)
To: Robert Treat <xzilla@users.sourceforge.net>; +Cc: pgsql-docs@postgresql.org, Jeff Frost <jeff@frostconsultingllc.com>
Robert Treat wrote:
> On Tuesday 16 October 2007 01:38, Bruce Momjian wrote:
> > 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.
>
> I might question the strict reference to Slony here. AIUI you could do the
> same thing with Bucardo and a couple of other replication solutions as well.
OK, I now say "like Slony":
It is also possible to use replication like <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 seconds
of downtime for an upgrade.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2007-10-16 19:44 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-10-16 02:50 Slony for upgrades Bruce Momjian <bruce@momjian.us>
2007-10-16 05:11 ` Jeff Frost <jeff@frostconsultingllc.com>
2007-10-16 05:38 ` Bruce Momjian <bruce@momjian.us>
2007-10-16 18:21 ` Robert Treat <xzilla@users.sourceforge.net>
2007-10-16 19:44 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox