pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
To: fabriziomello@gmail.com, Andres Freund <andres@2ndquadrant.com>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Pgsql Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Time-Delayed Standbys
Date: Thu, 12 Dec 2013 17:19:21 +0900
Message-ID: <52A97189.2040009@lab.ntt.co.jp> (raw)
In-Reply-To: <CAFcNs+rMzSMPCAkD3ZN1b442i_euqxi5W_mjhzh6OQS9waHQag@mail.gmail.com>
References: <CA+TgmoaCL4G+YotjjjFM+J_h0nSkp4gXiiBPDQGHxTcc_T0w-w@mail.gmail.com>
	<CAFcNs+r-GyizHAPDvRz=3XR3BYLUqxpqxrvJq8spk4PJe5hxAA@mail.gmail.com>
	<52A59D10.7020209@lab.ntt.co.jp>
	<52A5A095.5020002@lab.ntt.co.jp>
	<20131209112937.GA27840@awork2.anarazel.de>
	<52A697F3.8030403@lab.ntt.co.jp>
	<20131210093848.GG27840@awork2.anarazel.de>
	<52A807F5.4020203@lab.ntt.co.jp>
	<CA+U5nMKoiXbX2iPJSEyxYiT2M2KBXbZcbi2BQAXVZr+eSFQD-g@mail.gmail.com>
	<CAFcNs+qPYEzJ-jRBH31VppG=_F1-9gwR_T2iRqru-i-4rdRLrA@mail.gmail.com>
	<20131211214712.GA536@awork2.anarazel.de>
	<CAFcNs+rMzSMPCAkD3ZN1b442i_euqxi5W_mjhzh6OQS9waHQag@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

(2013/12/12 7:23), Fabrízio de Royes Mello wrote:
> On Wed, Dec 11, 2013 at 7:47 PM, Andres Freund <andres@2ndquadrant.com
>  > * hot_standby=off: Makes delay useable with wal_level=archive (and thus
>  >   a lower WAL volume)
>  > * standby_mode=off: Configurations that use tools like pg_standby and
>  >   similar simply don't need standby_mode=on. If you want to trigger
>  >   failover from within the restore_command you *cannot* set it.
>  > * recovery_target_*: It can still make sense if you use
>  >   pause_at_recovery_target.

I don't think part of his arguments are right very much... We can just set 
stanby_mode=on when we use "min_standby_apply_delay" with pg_standby and similar 
simply tools. However, I tend to agree with not to need to prohibit except for 
standby_mode. So I'd like to propose that changing parameter name of 
"min_standby_apply_delay" to "min_recovery_apply_delay". It is natural for this 
feature.

Regards,
--
Mitsumasa KONDO
NTT Open Source Software Center


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers



view thread (114+ messages)  latest in thread

Message-ID: <52A97189.2040009@lab.ntt.co.jp>
Permalink:  ../52A97189.2040009@lab.ntt.co.jp/
Also on:    postgresql.org/message-id/52A97189.2040009@lab.ntt.co.jp

 · 

reply
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: kondo.mitsumasa@lab.ntt.co.jp, andres@2ndquadrant.com, simon@2ndquadrant.com, robertmhaas@gmail.com
  Subject: Re: Time-Delayed Standbys
  In-Reply-To: <52A97189.2040009@lab.ntt.co.jp>

* 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