From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problem with pg_upgrade 8.3 to 9.1.4 - clog missing?! |
Date: | 2012-06-13 19:24:20 |
Message-ID: | 20120613192420.GA15644@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Jun 13, 2012 at 02:55:41PM -0400, Bruce Momjian wrote:
> On Wed, Jun 13, 2012 at 08:43:23PM +0200, hubert depesz lubaczewski wrote:
> > On Wed, Jun 13, 2012 at 02:32:21PM -0400, Bruce Momjian wrote:
> > > I assume 8.3 vacuumdb did not generate these errors. If it was 8.4 I
> > > would suggest it was because we don't copy visibility map files from
> > > pre-9.1 because those were not crash-safe, but 8.3 didn't have
> > > visibility map files (added in PG 8.4), so 8.3 should have been checking
> > > the exact same transaction ids as 9.1.
> > >
> > > Basically, I can't think of a cause.
> >
> > yeah, neither can we. but - any other test - even using the same source
> > of $PGDATA went flawless. I'm tempted to assume it's just a random
> > glitch in matrix, and just go on.
>
> Is the vacuumdb still repeatedly failing?
well - in this particular upgraded database - i think so. I did run it
couple of times, it failed all the times.
But this $PGDATA is not longer used - we did another tests, and no other
test showed problems - i.e. vacuum worked fine.
Best regards,
depesz
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2012-06-13 19:32:36 | Re: composite type use in pl/gpsql |
Previous Message | Bruce Momjian | 2012-06-13 18:55:41 | Re: Problem with pg_upgrade 8.3 to 9.1.4 - clog missing?! |