On Mon, 2020-06-15 at 20:59 -0400, Bruce Momjian wrote: > On Sat, Jun 13, 2020 at 08:46:36AM -0400, Bruce Momjian wrote: > > On Wed, Jun 10, 2020 at 04:07:05PM +0200, Laurenz Albe wrote: > > > A customer's upgrade failed, and it took me a while to > > > figure out that the problem was that they had set > > > "vacuum_defer_cleanup_age=10000" on the new cluster. > > > > > > The consequence was that the "vacuumdb --freeze" that > > > takes place before copying commit log files failed to > > > freeze "pg_database". > > > That caused later updates to the table to fail with > > > "Could not open file "pg_xact/0000": No such file or directory." > > > > > > I think it would increase the robustness of pg_upgrade to > > > force "vacuum_defer_cleanup_age" to 0 on the new cluster. > > Thank you, applied to all supported PG versions.
Thanks for picking this up and taking care of it. Yours, Laurenz Albe
