Re: pg_upgrade fails if vacuum_defer_cleanup_age > 0

2020-06-16 Thread Bruce Momjian
On Tue, Jun 16, 2020 at 08:39:57AM +0200, Laurenz Albe wrote: > 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

Re: pg_upgrade fails if vacuum_defer_cleanup_age > 0

2020-06-15 Thread Laurenz Albe
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

Re: pg_upgrade fails if vacuum_defer_cleanup_age > 0

2020-06-15 Thread Bruce Momjian
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=1" on the new cluster. >

Re: pg_upgrade fails if vacuum_defer_cleanup_age > 0

2020-06-13 Thread Bruce Momjian
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=1" on the new cluster. > > The consequence was that the "vacuumdb --freeze" that > takes place

pg_upgrade fails if vacuum_defer_cleanup_age > 0

2020-06-10 Thread Laurenz Albe
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=1" 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 cause