Re: Postgresql Data corruption

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(dot)romero(dot)b(at)gmail(dot)com> wrote:

> 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/
>
>

--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/