RE: [ADMIN] SOS !!: Porstgress forgot all ! Help !

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Jean-Arthur Silve'" <jeanarthur(at)eurovox(dot)fr>
Cc: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: [ADMIN] SOS !!: Porstgress forgot all ! Help !
Date: 2001-02-12 17:51:27
Message-ID: 8F4C99C66D04D4118F580090272A7A234D32E8@sectorbase1.sectorbase.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-02-12 17:55:52 Re: Table name scope (was Re: Outer joins aren't working with views)
Previous Message Kovacs Zoltan 2001-02-12 17:49:00 pg_dump output