Re: remove pg_standby?

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: hlinnaka(at)iki(dot)fi, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: remove pg_standby?
Date: 2015-03-02 23:22:00
Message-ID: CAHGQGwHAOKm-ndv2U5YMhzDEmK+xt3f4_LjZa_9kqsBv1WDwyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Mar 3, 2015 at 3:07 AM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>
>> Per document,
>>
>> ------------------
>> In fast failover, the server is brought up immediately. Any WAL files
>> in the archive that have not yet been applied will be ignored, and all
>> transactions in those files are lost. To trigger a fast failover,
>> create a trigger file and write the word fast into it. pg_standby can
>> also be configured to execute a fast failover automatically if no new
>> WAL file appears within a defined interval.
>> ------------------
>
> I thought we had that as a 9.4 feature, actually. Well wait ... that's
> for streaming.

s/9.4/9.3?

That's different from one we had in 9.3. Fast failover that pg_standby
supports is something like the feature that I was proposing at
http://www.postgresql.org/message-id/CAHGQGwHtvyDqKZaYWYA9zyyLEcAKiF5P0KpcpuNE_tsrGTFtQw@mail.gmail.com
that is, the feature which allows us to give up replaying remaining
WAL data for some reasons at the standby promotion. OTOH, fast
failover that was supported in 9.3 enables us to skip an end-of-recovery
checkpoint at the promotion and reduce the failover time.

Regards,

--
Fujii Masao

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Nasby 2015-03-02 23:22:18 Re: Idea: GSoC - Query Rewrite with Materialized Views
Previous Message Josh Berkus 2015-03-02 23:18:16 Patch: raise default for max_wal_segments to 1GB