Postgresql Error

[sanjaybandhaniya]

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?

[kaynezhang]

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-inde... 

[sanjaybandhaniya]

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

[kaynezhang]

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.

[sanjaybandhaniya]

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

[kaynezhang]

postgresql data directory