On Tue, Jul 6, 2021 at 10:32:24AM -0700, Peter Geoghegan wrote:
> On Tue, Jul 6, 2021 at 10:27 AM Bruce Momjian <bruce@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 <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.