how reliable is pg_rewind?

2020-08-02 Thread Curt Kolovson
When trying to resync an old primary to become a new standby, I have found that pg_rewind only works occasionally. How reliable/robust is pg_rewind, and what are its limitations? We have observed that approx half our FPIs in the WALs are due to XLOG/FPI_FOR_HINT. The only reason we've set wal_log_h

Re: how reliable is pg_rewind?

2020-08-03 Thread Curt Kolovson
Thanks, Paul and Michael. I forgot to mention that we're using postgres v10.12. On Sun, Aug 2, 2020 at 10:29 PM Paul Förster wrote: > Hi Curt, hi Michael, > > > On 03. Aug, 2020, at 03:58, Michael Paquier wrote: > > > > On Sat, Aug 01, 2020 at 10:35:37AM -0700,