From:
Simon Riggs <simon(at)2ndQuadrant(dot)com>
To:
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc:
Dimitri Fontaine <dfontaine(at)hi-media(dot)com>,
Fujii Masao <masao(dot)fujii(at)gmail(dot)com>,
Magnus Hagander <magnus(at)hagander(dot)net>,
Robert Haas <robertmhaas(at)gmail(dot)com>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Streaming replication, retrying from archive
Date:
2010-01-20 23:32:11
Message-ID:
1264030331.4043.5666.camel@ebony (view raw or flat )
Thread:
2010-01-14 14:15:14 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-01-14 14:36:11 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-14 14:39:59 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-14 15:23:26 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-01-14 16:06:36 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-14 16:43:51 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-01-14 19:36:07 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-15 18:11:00 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-01-15 18:56:41 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-16 10:36:19 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-20 19:26:37 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-01-20 23:32:11 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-01-21 22:09:53 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-21 22:15:25 from Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
2010-01-14 16:28:03 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-01-14 22:19:48 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-01-15 02:38:28 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-01-14 20:13:46 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-14 21:02:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-hackers
On Wed, 2010-01-20 at 21:26 +0200, Heikki Linnakangas wrote:
> So there's just two states:
>
> 1. Recovering from archive
> 2. Streaming
>
> We start from 1, and switch state at error.
>
> This gives nice behavior from a user point of view. Standby tries to
> make progress using either the archive or streaming, whichever becomes
> available first.
Sounds good. Easier to drive if we have two gears.
--
Simon Riggs www.2ndQuadrant.com
In response to
pgsql-hackers by date
Next :From: Mark KirkwoodDate: 2010-01-21 00:37:44
Subject : Re: Streaming Replication and archiving
Previous :From : Tom LaneDate : 2010-01-20 23:22:01
Subject : Re: Streaming Replication and archiving