On Fri, Jan 21, 2005 at 03:33:28PM +0200, Kristaps Armanis wrote: > Last night no crash, not anything, just @ one moment all records for > last year where gone, all ros created for last year & tables created > while this time - and not in only one database, but all 6 DB's on this > server.
Looks like XID wraparound, you hit the 4 billion transaction mark. This was fixed in 7.2 IIRC. Unfortunatly I don't know of an easy way to recover, but this should give you something to search the archives for. Hope this helps, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
pgpuhTHkiQ9z8.pgp
Description: PGP signature
