On Tue, Jan 14, 2020 at 2:55 PM Tulqin Navruzov < tulqin.navru...@finnetlimited.com> wrote:
> > > Hi team > > Could you help us to sort this out please? > > 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: https://wiki.postgresql.org/wiki/Corruption 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. -- El genio es 1% inspiraciĆ³n y 99% transpiraciĆ³n. Thomas Alva Edison http://pglearn.blogspot.mx/