Re: Strange problem when upgrading to 7.2 with pg_upgrade. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Strange problem when upgrading to 7.2 with pg_upgrade.
Date
Msg-id 14275.1014354508@sss.pgh.pa.us
Whole thread Raw
In response to Re: Strange problem when upgrading to 7.2 with pg_upgrade.  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Strange problem when upgrading to 7.2 with pg_upgrade.  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Strange problem when upgrading to 7.2 with pg_upgrade.  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> I suspect that pg_upgrade has neglected to make sure the clog is long
>> enough.

> Here is the code that sets the transaction id.  Tom, does pg_resetxlog
> handle pg_clog file creation properly?

pg_resetxlog doesn't know a single solitary thing about the clog.

The problem here is that if you're going to move the current xact ID
forward, you need to be prepared to create pages of the clog
accordingly.  Or maybe the clog routines need to be less rigid in their
assumptions, but I'm uncomfortable with relaxing their expectations
unless it can be shown that they may fail to cope with cases that
arise in normal system operation.  This isn't such a case.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Strange problem when upgrading to 7.2 with pg_upgrade.
Next
From: Bruce Momjian
Date:
Subject: Re: Strange problem when upgrading to 7.2 with pg_upgrade.