Re: Fwd: Postgresql Data corruption

On 1/14/20 12:44 PM, Tulqin Navruzov 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?

Do you have space to back up the $DATADIR or do you have a recent backup?

Asking because that would be helpful before you try the below.

I would take a look at:
https://www.postgresql.org/docs/12/sql-reindex.html

In section:

Notes

...

Things are more difficult if you need to recover from corruption of an
index on a system table. ...

For more information on single-user mode:

https://www.postgresql.org/docs/12/app-postgres.html#APP-POSTGRES-SINGLE-USER

>
> Thanks in advance.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com