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

From Bruce Momjian
Subject Re: Strange problem when upgrading to 7.2 with pg_upgrade.
Date
Msg-id 200202221240.g1MCenw18554@candle.pha.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>)
List pgsql-hackers
> We increased the xid because the old files have xid's that are greater
> than the newly initdb'ed database.  We did a vacuum, so no one is going
> to check clog, but we need to increase the transaction counter because
> old rows could be seen as matching the current transaction.
> 
> Can you suggest how to create the needed clog files?  I don't see any
> value in changing your current clog code in the backend.

Tom, is there a way to increment the XID every 100 million and start the
postmaster to create the needed pg_clog files to get to the XID I need?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: [ODBC] UTF-8 data migration problem in Postgresql 7.2
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Re: nocreatetable for 7.1.2 [patch]