My 7.2.1 database was in the middle of inserting a large object when the power went down. When I restart the database I getting the following messages:
postgres: startup subprocess : DEBUG sql sql sql DEBUG: database system was interrupted at 2003-10-08 09:29:12 PDT
postgres: startup subprocess : DEBUG sql sql sql DEBUG: checkpoint
postgres: startup subprocess : DEBUG sql sql sql DEBUG: redo record is at 0/115A3C; undo record is at 0/0; shutdown TRUE
postgres: startup subprocess : DEBUG sql sql sql DEBUG: next transaction id: 95; next oid: 16557
postgres: startup subprocess : DEBUG sql sql sql DEBUG: database system was not properly shut down; automatic recovery in progress
postgres: startup subprocess : DEBUG sql sql sql DEBUG: redo starts at 0/115A7C
postgres: startup subprocess : DEBUG sql sql sql DEBUG: ReadRecord: record with zero length at 0/157F4C
postgres: startup subprocess : DEBUG sql sql sql DEBUG: redo done at 0/157F28
postgres: startup subprocess : DEBUG sql sql sql DEBUG: database system is ready
When I vacuum the database to remove used entries and to compact the db, I get the following errors:
postgres: voicemail aesop 127.0.0.1 VACUUM: DEBUG sql sql sql DEBUG --Relation pg_largeobject--
postgres: voicemail aesop 127.0.0.1 VACUUM: INFO sql sql sql NOTICE: Rel pg_largeobject: TID 1/1: InsertTransactionInProgress 0 - can't shrink relation
postgres: voicemail aesop 127.0.0.1 VACUUM: INFO sql sql sql NOTICE: Rel pg_largeobject: TID 1/2: InsertTransactionInProgress 0 - can't shrink relation
postgres: voicemail aesop 127.0.0.1 VACUUM: INFO sql sql sql NOTICE: Rel pg_largeobject: TID 1/4: InsertTransactionInProgress 0 - can't shrink relation
postgres: voicemail aesop 127.0.0.1 VACUUM: CRASH sql sql sql FATAL2: open of /data/sql/pg_clog/09C6 failed: No such file or directory
postmaster: DEBUG sql sql sql DEBUG: server process (pid 1393) exited with exit code 2
postmaster: DEBUG sql sql sql DEBUG: terminating any other active server processes
postmaster: ERROR sql sql sql FATAL 1: The database system is in recovery mode
and from then on any time we try to connect we get a message saying database is in recovery mode and it never comes out. How can I recover this database or do I have to restore a prior backup?
Chris White
