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?


Fri, 18 May 2001 23:42:47 -0400 (EDT)
Alex Pilosov <alex@pilosoft.com>
force of last XID
> 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?

Try copying over the pg_log file from the old database.  That should
help.

-- 
  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, Pennsylvania 19026

Fri, 18 May 2001 23:58:52 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: force of last XID