postgres will not start up - corrupted on restart

Поиск
Список
Период
Сортировка
От Nicholas Wilson
Тема postgres will not start up - corrupted on restart
Дата
Msg-id CABgBcYNSNqDbqzr5R1w-rQqhFGG1QGz+yig02MtsB+5FEEBLqw@mail.gmail.com
обсуждение исходный текст
Ответы Re: postgres will not start up - corrupted on restart  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
I'm running postgresql 9.0. 
I was running several processes and did "sudo service postgres restart" and it has thrown a fit.

2012-02-24 12:45:13 PST:[local]:[unknown]@[unknown]:[16969]: LOG:  incomplete startup packet
2012-02-24 12:45:13 PST::@:[16968]: LOG:  database system was not properly shut down; automatic recovery in progress
2012-02-24 12:45:13 PST::@:[16968]: LOG:  consistent recovery state reached at 35E/C009D2B0
2012-02-24 12:45:13 PST::@:[16968]: LOG:  redo starts at 35E/8503C678
2012-02-24 12:45:13 PST::@:[16968]: PANIC:  GIN metapage disappeared
2012-02-24 12:45:13 PST::@:[16968]: CONTEXT:  xlog redo Update metapage, node: 1663/16558714/114537692 blkno: 85
2012-02-24 12:45:13 PST::@:[16967]: LOG:  startup process (PID 16968) was terminated by signal 6: Aborted
2012-02-24 12:45:13 PST::@:[16967]: LOG:  aborting startup due to startup process failure


Not sure if anyone can point me in the right direction. I didn't install the server but I'm one of the people who uses it extensively. But I broke it and now I need to fix it...

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

Предыдущее
От: Tanstaafl
Дата:
Сообщение: Re: Sanitizing text being stored in text fields - some characters cause problems
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: Sanitizing text being stored in text fields - some characters cause problems