On Tue, Jul 6, 2021 at 10:32:24AM -0700, Peter Geoghegan wrote: > On Tue, Jul 6, 2021 at 10:27 AM Bruce Momjian <br...@momjian.us> wrote: > > OK, this is confirmation that the pg_resetwal bug, and its use by > > pg_upgrade, is a serious issue that needs to be addressed. I am > > prepared to work on it now. > > To be clear, I'm not 100% sure that this is related to the pg_upgrade > + "pg_resetwal sets oldestXid to an invented value" issue. I am sure > that that is a serious issue that needs to be addressed sooner rather > than later, though.
Well, pg_upgrade corruptions are rare, but so is modifying autovacuum_freeze_max_age. If we have a corruption and we know autovacuum_freeze_max_age was modified, odds are that is the cause. -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.
