force of last XID - Mailing list pgsql-hackers

From Alex Pilosov
Subject force of last XID
Date
Msg-id Pine.BSO.4.10.10105182340360.18557-100000@spider.pilosoft.com
Whole thread Raw
Responses Re: force of last XID  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Hi,

I managed to drop really important table. Fortunately, I had a backup of
the table (raw #### file, not a ascii file). After putting that table into
freshly initdb'd database, postgres doesn't see new transactions even
though 'vacuum' sees the tuples alright. 

So, question. I'd like to force XID (of last committed transaction) of
postgres forward. Is there a good way to do it or hacking source is the
only way?



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Interesting question
Next
From: Tom Lane
Date:
Subject: Re: Plans for solving the VACUUM problem