From: Bimal <internetuser2008@yahoo.com>
To: pgsql-admin@postgresql.org, Jerry Sievers <gsievers19@comcast.net>
Subject: Re: Wal fetching standby refuses to promote
Date: Sun, 18 Mar 2018 16:26:42 +0000 (UTC)
Message-ID: <1195397079.2731184.1521390402043@mail.yahoo.com> (raw)
In-Reply-To: <87a7v9rzpe.fsf@jsievers.enova.com>
References: <87a7v9rzpe.fsf@jsievers.enova.com>
You can try to add the trigger file in recovery.conf and perform a promote. Never tried but should work. On Thursday, March 15, 2018, 10:56:06 AM PDT, Jerry Sievers <gsievers19@comcast.net> wrote:
This was an atomic snapshot put in recovery and happily reading WALs
from the repo.
It's consistent and allows read-only querying. It's replayed a few days
worth of WALs and was previously running with a recovery_target_xid =
$some-xid which apparently was never hit and/or aborted.
It would not promote then, after pg_ctl promote. The 'promote' file did
get created in pgdata.
Now it's running again with recovery.conf that contains just...
standby_mode = on
restore_command = 'cp /somedir/%f %p'
Still it fails to respond to the issuance of a promote.
There is no trigger file config's in recovery.conf and we have never
needed to do same since pg_ctl promote usually works.
Any idea what's causing this?
Thanks
version
-----------------------------------------------------------------------------------------------------------------
PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.4) 5.4.0 20160609, 64-bit
(1 row)
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800
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: internetuser2008@yahoo.com, gsievers19@comcast.net
Subject: Re: Wal fetching standby refuses to promote
In-Reply-To: <1195397079.2731184.1521390402043@mail.yahoo.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