Fwd: Postgresql Data corruption - Mailing list pgsql-general

From Tulqin Navruzov
Subject Fwd: Postgresql Data corruption
Date
Msg-id CANb6iOF68v34C+WcQiQQ=HRrjz-bpYP3cZcbREQaXSxU7UU0Hw@mail.gmail.com
Whole thread Raw
Responses Re: Postgresql Data corruption
Re: Fwd: Postgresql Data corruption
List pgsql-general


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.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Multiple Aggregations Order
Next
From: Justin
Date:
Subject: Re: Is it possible to replicate through an http proxy?