From: Peter Eisentraut <peter_e@gmx.net>
To: Scott Mead <scottm@openscg.com>
To: John Scalia <jayknowsunix@gmail.com>
Cc: Keith Fiske <keith@omniti.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: a new standby server promotes itself to primary without cause
Date: Fri, 9 Oct 2015 16:45:36 -0400
Message-ID: <56182770.9050700@gmx.net> (raw)
In-Reply-To: <CAKq0gvJHhgXP_mFq75rV7-ByxV9Xfv2nNomb_k+xbg7Mmz4YRA@mail.gmail.com>
References: <CABzCKRBZguVgWw0hL7QjkEnOabVhEbaV7WDBhkO+-MCD=aNsnQ@mail.gmail.com>
<CAG1_KcAXoNRRk50RQpHwO77WSFWJfqrfNbs116ji1Xw4UhNJvA@mail.gmail.com>
<CABzCKRA0iCFzn6Og56jwbmF4P_44J7r0tEndMJPzt9xU74oC+A@mail.gmail.com>
<CAKq0gvJHhgXP_mFq75rV7-ByxV9Xfv2nNomb_k+xbg7Mmz4YRA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 10/8/15 11:04 AM, Scott Mead wrote:
> restore_command = 'cp /var/lib/pgsql/9.4/share/%f %p' #
> e.g. 'cp /mnt/server/archivedir/%f %p'
> archive_cleanup_command = '/usr/pgsql-9.4/bin/pg_archivecleanup
> /var/lib/pgsql/9.4/share %r'
> #recovery_end_command = ''
> #recovery_target_name = '' # e.g. 'daily backup 2011-01-26'
> #recovery_target_time = '' # e.g. '2004-07-14 22:39:00 EST'
> #recovery_target_xid = ''
> #recovery_target_inclusive = true
> recovery_target = 'immediate'
>
>
> I believe you should omit recovery_target.
> From http://www.postgresql.org/docs/9.4/static/recovery-target-settings.html
>
> recovery_target = 'immediate'
>
> This parameter specifies that recovery should end as soon as a
> consistent state is reached, i.e. as early as possible. When
> restoring from an online backup, this means the point where taking
> the backup ended.
Seems kind of weird that that would override the setting for standby_mode.
Isn't standby_mode = on effectively recovery_target = 'infinity'?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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-admin@postgresql.org
Cc: peter_e@gmx.net, scottm@openscg.com, jayknowsunix@gmail.com, keith@omniti.com
Subject: Re: a new standby server promotes itself to primary without cause
In-Reply-To: <56182770.9050700@gmx.net>
* 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