Re: Postgresql Data corruption

--000000000000cc0a20059c20d556
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Jan 14, 2020 at 2:55 PM Tulqin Navruzov <
[email protected]> 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 coul=
d
> 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 ca=
n
> 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.

--=20
El genio es 1% inspiraci=C3=B3n y 99% transpiraci=C3=B3n.
Thomas Alva Edison
http://pglearn.blogspot.mx/

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

<div dir=3D"ltr"><div dir=3D"ltr"><div>On Tue, Jan 14, 2020 at 2:55 PM Tulq=
in Navruzov &lt;<a href=3D"mailto:[email protected]">tulqin=
[email protected]</a>&gt; wrote:<br></div></div><div class=3D"gma=
il_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8=
ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr=
"><br><div class=3D"gmail_quote"><br><div dir=3D"ltr">Hi team=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;Structure needs to be =
cleaning &quot; during startup</div><div>, on centos7 did xfs_repair and po=
stgresql started successfully. But could not select datas from 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 s=
ystem index 2662<br></div><div><br></div><div>but can logged in with anothe=
r user and trying to select from some tables , showing this message :</div>=
<div><br></div><div>ERROR: =C2=A0catalog is missing 11 attribute(s) for rel=
id 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=A0this?</div><di=
v><br></div><div>Thanks in advance.</div></div>
</div></div>
</blockquote></div><br clear=3D"all"><div>First of all, please attend to th=
ese instructions:<div><a href=3D"https://wiki.postgresql.org/wiki/Corruptio=
n">https://wiki.postgresql.org/wiki/Corruption</a>=C2=A0=C2=A0</div></div><=
div><br></div><div>from what you describe looks like you need to restore fr=
om backups or promote a slave to master if you have such a setup and the sl=
ave(s) were not affected by these hardware problems.=C2=A0</div><div><br></=
div>-- <br><div dir=3D"ltr" class=3D"gmail_signature">El genio es 1% inspir=
aci=C3=B3n y 99% transpiraci=C3=B3n.<br>Thomas Alva Edison<br><a href=3D"ht=
tp://pglearn.blogspot.mx/" target=3D"_blank">http://pglearn.blogspot.mx/</a=
><br><div style=3D"padding:0px;margin-left:0px;margin-top:0px;overflow:hidd=
en;color:black;font-size:10px;text-align:left;line-height:130%"></div><div>=
<br></div></div></div>

--000000000000cc0a20059c20d556--