Postgres Pro
Downloads
Home   >   mailing lists

RE: [ADMIN] SOS !!: Porstgress forgot all ! Help ! - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: [ADMIN] SOS !!: Porstgress forgot all ! Help !
Date
Msg-id 8F4C99C66D04D4118F580090272A7A234D32E8@sectorbase1.sectorbase.com
Whole thread Raw
Responses Re: RE: [ADMIN] SOS !!: Porstgress forgot all ! Help !  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
> before this manipulmation, pg_log = 1.073.741.824

Ohhhh, your system reached max transaction ID -:(

> and xmin =  4982339

And now all tuples with xmin > ~5000000 are invisible.

One way to restore data could be hack vacuum to update
xmin of all valid tuples to 512, vacuum all tables,
dump data, initdb new fresh database etc -:((

Vadim

pgsql-hackers by date:

Previous
From: Kovacs Zoltan
Date:
Subject: pg_dump output
Next
From: Tom Lane
Date:
Subject: Re: Table name scope (was Re: [BUGS] Outer joins aren't working with views)