From: Heikki Linnakangas <hlinnaka@iki.fi>
To: Fujii Masao <masao.fujii@gmail.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: remove pg_standby?
Date: Mon, 02 Mar 2015 13:37:55 +0200
Message-ID: <54F44B93.401@iki.fi> (raw)
In-Reply-To: <CAHGQGwEE_8vvpQk0ex6Qa_aXt-OSJ7OdZjX4uM_FtqKfxq5SbQ@mail.gmail.com>
References: <545946E9.8060504@gmx.net>
<5460FAFF.2000805@commandprompt.com>
<5461087E.6090003@vmware.com>
<CABUevEz8WFUZjJ8DCEdjAmMog0WqJK5y0ncGObYb3c1C+C5q=g@mail.gmail.com>
<WM!29c59369fe1f0b948a6a2dd7534287d513b7a08380dc59c517d0f4daa3f2db0ce41cef11e42e1993e4e5467efbb6f9d6!@asav-2.01.com>
<54F0CCE3.7080507@agliodbs.com>
<CAHGQGwEE_8vvpQk0ex6Qa_aXt-OSJ7OdZjX4uM_FtqKfxq5SbQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
On 03/02/2015 11:53 AM, Fujii Masao wrote:
> On Sat, Feb 28, 2015 at 5:00 AM, Josh Berkus <josh@agliodbs.com> wrote:
>> On 11/10/2014 10:54 AM, Magnus Hagander wrote:
>>> On Mon, Nov 10, 2014 at 7:48 PM, Heikki Linnakangas
>>> <hlinnakangas@vmware.com> wrote:
>>>> pg_standby is more configurable than the built-in standby_mode=on. You can
>>>> set the sleep time, for example, while standby_mode=on uses a hard-coded
>>>> delay of 5 s. And pg_standby has a configurable maximum wait time. And as
>>>> Fujii pointed out, the built-in system will print an annoying message to the
>>>> log every time it attempts to restore a file. Nevertheless, 99% of users
>>>> would probably be happy with the built-in thing.
>>>
>>> As long as pg_standby has features that are actually useful and that
>>> are not in the built-in system, we shouldn't remove it. We should,
>>> however, try to fix those in the main system so we can get rid of it
>>> after that :)
>>
>> As of current 9.5, we have configurable retries and standby delay in
>> mainstream. Is there some reason we still need pg_standby?
>
> Yes, it's not easy to perform "fast failover" without pg_standby for now.
What is "fast failover"?
- Heikki
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: hlinnaka@iki.fi, masao.fujii@gmail.com, josh@agliodbs.com
Subject: Re: remove pg_standby?
In-Reply-To: <54F44B93.401@iki.fi>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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