Help with database recovery ...

Поиск
Список
Период
Сортировка
От Iztok Stotl
Тема Help with database recovery ...
Дата
Msg-id 1304278344.21857.2.camel@Hal
обсуждение исходный текст
Ответы Re: Help with database recovery ...
Список pgsql-general
My database crashed and server won't start ...

------------------------------------------------------
LOG:  database system was interrupted while in recovery at 2011-05-01
19:31:37 CEST
HINT:  This probably means that some data is corrupted and you will have
to use the last backup for recovery.
LOG:  checkpoint record is at 2/D41C1350
LOG:  redo record is at 2/D41C1350; undo record is at 0/0; shutdown
FALSE
LOG:  next transaction ID: 752151177; next OID: 50716
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system was not properly shut down; automatic recovery in
progress
LOG:  redo starts at 2/D41C1394
PANIC:  could not access status of transaction 752150401
DETAIL:  could not read from file "pg_clog/02CD" at offset 73728:
Success
LOG:  startup process (PID 3504) was terminated by signal 6
LOG:  aborting startup due to startup process failure
LOG:  logger shutting down
---------------------------------------------------------------
What can I do ?

[root@pg_log]# postgres --version
postgres (PostgreSQL) 8.1.18

OS is Centos.

Any hint ?


В списке pgsql-general по дате отправления:

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: pervasiveness of surrogate (also called synthetic) keys
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: pervasiveness of surrogate (also called synthetic) keys