Search Postgresql Archives

Re: Postgresql Data corruption

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Jan 14, 2020 at 2:55 PM Tulqin Navruzov <tulqin.navruzov@xxxxxxxxxxxxxxxxx> 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/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux