From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: guillaume.smet@gmail.com, Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: New trigger option of pg_standby
Date: Thu, 26 Mar 2009 08:20:58 +0200
Message-ID: <49CB1ECA.5030507@enterprisedb.com> (raw)
In-Reply-To: <3f0b79eb0903251851v5936d6b4x49997ac8f04b98b9@mail.gmail.com>
References: <3f0b79eb0903242329j12865d55s348f5c873a956e71@mail.gmail.com>
<1d4e0c10903242350i505a9f6bsa7ba347dc02f90b6@mail.gmail.com>
<3f0b79eb0903250144k453b3927mffa8b08678ed057b@mail.gmail.com>
<1d4e0c10903250155w34bd79dcvfab2ad5c95e56011@mail.gmail.com>
<49C9F255.EE98.0025.0@wicourts.gov>
<1d4e0c10903250848x4e067c86ue611c0c50f25e49d@mail.gmail.com>
<3f0b79eb0903251851v5936d6b4x49997ac8f04b98b9@mail.gmail.com>
Fujii Masao wrote:
> On Thu, Mar 26, 2009 at 12:48 AM, Guillaume Smet
> <guillaume.smet@gmail.com> wrote:
>> On Wed, Mar 25, 2009 at 2:59 PM, Kevin Grittner
>> <Kevin.Grittner@wicourts.gov> wrote:
>>> I find it hard to imagine a use case for the existing default
>>> behavior.
>> I thought a bit about it and I think it can be useful when your
>> priority is the availability of the service and you don't consider a
>> data loss that important: even if you have a lot of WALs segments to
>> replay, you may want to have your service up immediately in case of a
>> major problem.
>
> Yes, I also think that this is likely use case.
>
>> Keeping it is a good idea IMHO but I don't think it should be the default.
>
> What does "the default" mean? You mean that new trigger should use
> the existing trigger option character (-t)?
The existing behavior doesn't seem very useful to me either. Assuming
there is a use case though, we probably need to support both at the same
time, perhaps using different trigger files. If there's a use case for
both, conceivably someone will want to sometimes trigger the failover
immediately and sometimes after all WAL segments have been replayed.
Whatever we do, the signaling method to trigger failover should behave
the same.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
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: heikki.linnakangas@enterprisedb.com, masao.fujii@gmail.com, Kevin.Grittner@wicourts.gov
Subject: Re: New trigger option of pg_standby
In-Reply-To: <49CB1ECA.5030507@enterprisedb.com>
* 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