topic Re: Postgresql Error in Alfresco Forum

Postgresql Error

sp2 — Tue, 13 Oct 2020 15:43:26 GMT

Hi,

I am facing below error during postgresql db start.

FATAL: the database system is starting up

FATAL: failed to re-find parent key in index "16619" for split pages 915114/915115

What is the solution of this error?

Re: Postgresql Error

kaynezhang — Wed, 14 Oct 2020 02:22:22 GMT

It seems your postgresql index is corrupted
Please refer to https://dba.stackexchange.com/questions/135881/postgresql-error-failed-to-re-find-parent-key-in-index

Re: Postgresql Error

sp2 — Wed, 14 Oct 2020 02:51:28 GMT

To Make reindex, I need to start DB but I am not able to start. Without start, How Can I do?

Re: Postgresql Error

kaynezhang — Wed, 14 Oct 2020 04:12:57 GMT

Please check whether the user you are using to run postgrelsql has lost file system permission first. I have met similar error before ,it was cause by file permission was error accidentally modified by other user.

Re: Postgresql Error

sp2 — Wed, 14 Oct 2020 06:02:32 GMT

file system permission?For which file I need to check and how?

Re: Postgresql Error

kaynezhang — Wed, 14 Oct 2020 13:03:29 GMT

postgresql data directory