db recovery (FATAL 2)
От | Bojan Belovic |
---|---|
Тема | db recovery (FATAL 2) |
Дата | |
Msg-id | 20020507142203.4114.qmail@uwdvg001.cms.usa.net обсуждение исходный текст |
Ответы |
Re: db recovery (FATAL 2)
data loss due to improper handling of postmaster .... |
Список | pgsql-admin |
My database apparently crashed - don't know how or why. It happend in the middle of the night so I wasn't around to troubleshoot it at the time. It looks like it died during the scheduled vacuum. Here's the log that gets generated when I attempt to bring it back up: postmaster successfully started DEBUG: database system shutdown was interrupted at 2002-05-07 09:35:35 EDT DEBUG: CheckPoint record at (10, 1531023244) DEBUG: Redo record at (10, 1531023244); Undo record at (10, 1531022908); Shutdown FALSE DEBUG: NextTransactionId: 29939385; NextOid: 9729307 DEBUG: database system was not properly shut down; automatic recovery in progress... DEBUG: redo starts at (10, 1531023308) DEBUG: ReadRecord: record with zero len at (10, 1575756128) DEBUG: redo done at (10, 1575756064) FATAL 2: write(logfile 10 seg 93 off 15474688) failed: Success /usr/bin/postmaster: Startup proc 1339 exited with status 512 - abort Any suggestions? What are my options, other than doing a complete restore of the DB from a dump (which is not really an option as the backup is not as recent as it should be). Thanks! Bojan
В списке pgsql-admin по дате отправления: