Re: Warm standby can't start because logs stream too quickly from the master

2017-12-02 Thread Zach Walton
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

Re: Warm standby can't start because logs stream too quickly from the master

2017-12-02 Thread Jeff Janes
On Sat, Dec 2, 2017 at 11:02 AM, Zach Walton wrote: > Looking at the startup process: > > postgres 16749 4.1 6.7 17855104 8914544 ?Ss 18:36 0:44 postgres: > startup process recovering 00085B1C0030 > > Then a few seconds later: > > postgres 16749 4.2

Re: Warm standby can't start because logs stream too quickly from the master

2017-12-02 Thread Joshua D. Drake
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

Warm standby can't start because logs stream too quickly from the master

2017-12-02 Thread Zach Walton
Looking at the startup process: postgres 16749 4.1 6.7 17855104 8914544 ?Ss 18:36 0:44 postgres: startup process recovering 00085B1C0030 Then a few seconds later: postgres 16749 4.2 7.0 17855104 9294172 ?Ss 18:36 0:47 postgres: startup process recovering