This was my fault. I'd restored recovery.conf from recovery.done to try to recover manually after automated recovery failed. Everything's working after stopping the database and running pgpool online recovery again.
Thanks for the help.
On Sat, Dec 2, 2017 at 1:55 PM, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> wrote:
On 12/02/2017 11:02 AM, Zach Walton wrote:
Generally this works itself out if I wait (sometimes a really long time). Is there a configuration option that allows a warm standby to start without having fully replayed the logs from the master?
* Note: wal_keep_segments is set to 8192 on these servers, which have large disks, to allow for recovery within a couple of hours of a failover without resorting to restoring from archive
* This is specifically an issue for pgpool recovery, which fails if a standby can't start within (by default) 300 seconds. Open to toggling that param if there's no way around this.
It needs to only reach a consistent state, it doesn't need restore all logs. What does your recovery.conf say and are you *100% sure% you issued a pg_stop_backup()?
JD
--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
PostgreSQL Centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://pgconf.org
***** Unless otherwise stated, opinions are my own. *****
