Re: Postgresql Data corruption

On Tue, Jan 14, 2020 at 2:55 PM Tulqin Navruzov <
tulqin(dot)navruzov(at)finnetlimited(dot)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/