Can't help you personally right now due to work, but try these guys: https://pgexperts.com/services/emergency_help/
On Tue, Jan 14, 2020 at 4:08 PM Rene Romero Benavides < rene.romer...@gmail.com> wrote: > 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/ > > -- El genio es 1% inspiración y 99% transpiración. Thomas Alva Edison http://pglearn.blogspot.mx/
