Re: can't start postgresql

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: can't start postgresql
Дата
Msg-id 20061114153420.GA30115@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: can't start postgresql  (Matthias.Pitzl@izb.de)
Ответы Re: can't start postgresql  (Igor Shevchenko <igor@carcass.ath.cx>)
Список pgsql-general
Matthias.Pitzl@izb.de wrote:
> He's just trying to do what you told him.
> But the use of initdb won't correct the problem Igor got. There's something
> wrong with his database so that he can't start the postmaster process:
> > PANIC:  failed to re-find parent key in "23724"
>
> Unfortunately i don't have any idea how to solve this issue :(

I'd think starting a standalone backend and issuing a "reindex database"
should be enough to get him started.  Now, the problem is figuring _how_
the index got in that state; or even _what_ index is the problematic
one.  (I think it would be possible to find out by setting the
"log_error_verbosity" parameter to "verbose").

If it's a hardware problem, one would think it deserves some diagnosis.
It could be the btree bug Tom fixed last week, but I'm not sure if this
is really a consequence of it.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

Предыдущее
От: Matthias.Pitzl@izb.de
Дата:
Сообщение: Re: can't start postgresql
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: can't start postgresql