We had some hardware problems with Datacenter and could not using postgresql from restored snapshots it showing "Structure needs to be cleaning " during startup
, on centos7 did xfs_repair and postgresql started successfully. But could not select datas from it . showing below message .
This is when want to login to db with postgres user .
psql: PANIC: could not open critical system index 2662
but can logged in with another user and trying to select from some tables , showing this message :
ERROR: catalog is missing 11 attribute(s) for relid 113971
Could you help us to solve this problem? or could you give contact who can help with this?
Thanks in advance.
First of all, please attend to these instructions:
from what you describe looks like you need to restore from backups or promote a slave to master if you have such a setup and the slave(s) were not affected by these hardware problems.