> 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