Fwd: Postgresql Data corruption

--000000000000393092059c1faaee
Content-Type: text/plain; charset="UTF-8"

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.

--000000000000393092059c1faaee
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><br><div class=3D"gmail_quote"><br><div dir=3D"ltr">Hi tea=
m=C2=A0<div><br></div><div>Could you help us to sort=C2=A0this out please?<=
/div><div><br></div><div>We had some hardware problems with Datacenter and =
could not using postgresql from restored snapshots it showing &quot;Structu=
re needs to be cleaning &quot; during startup</div><div>, on centos7 did xf=
s_repair and postgresql started successfully. But could not select datas fr=
om it . showing below message .</div><div><br></div><div>This is when want =
to login to db with postgres user .</div><div>psql: PANIC: =C2=A0could not =
open critical system index 2662<br></div><div><br></div><div>but can logged=
 in with another user and trying to select from some tables , showing this =
message :</div><div><br></div><div>ERROR: =C2=A0catalog is missing 11 attri=
bute(s) for relid 113971<br></div><div><br></div><div>Could you help us to =
solve this=C2=A0problem? or could you give contact who can help with=C2=A0t=
his?</div><div><br></div><div>Thanks in advance.</div></div>
</div></div>

--000000000000393092059c1faaee--