Search Postgresql Archives

Re: can't start postgresql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Matthias.Pitzl@xxxxxx 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux