Subject: Re: a new standby server promotes itself to primary without
 cause
To: Scott Mead <scottm@openscg.com>, John Scalia <jayknowsunix@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>
Cc: Keith Fiske <keith@omniti.com>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
From: Peter Eisentraut <peter_e@gmx.net>
Message-ID: <56182770.9050700@gmx.net>
Date: Fri, 9 Oct 2015 16:45:36 -0400
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:38.0)
 Gecko/20100101 Thunderbird/38.3.0
MIME-Version: 1.0
In-Reply-To: 
 <CAKq0gvJHhgXP_mFq75rV7-ByxV9Xfv2nNomb_k+xbg7Mmz4YRA@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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