oids rollover? - Mailing list pgsql-hackers

From Daniel Kalchev
Subject oids rollover?
Date
Msg-id 200206242047.g5OKlAu13306@dcave.digsys.bg
Whole thread Raw
Responses Re: oids rollover?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
o
I have a problem with an 7.1.3 database that has probably overflowed
the oid counter. The startup halts with these messages

DEBUG:  database system was interrupted at 2002-06-24 21:19:43 EEST
DEBUG:  CheckPoint record at (156, 1692817164)
DEBUG:  Redo record at (156, 1692775580); Undo record at (0, 0);
Shutdown FALSE
DEBUG:  NextTransactionId: 859255800; NextOid: 7098
FATAL 2:  Invalid NextTransactionId/NextOid
postmaster: Startup proc 4752 exited with status 512 - abort


Can something be sone to recover the database?

Regards,
Daniel




pgsql-hackers by date:

Previous
From: cbbrowne@cbbrowne.com
Date:
Subject: Re: A fairly obvious optimization?
Next
From: Tom Lane
Date:
Subject: Re: Index Scans become Seq Scans after VACUUM ANALYSE