Re: Fwd: Postgresql Data corruption

--vs0rQTeTompTJjtd
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Tue, Jan 14, 2020 at 02:34:04PM -0800, Adrian Klaver wrote:
> On 1/14/20 12:44 PM, Tulqin Navruzov wrote:
>> but can logged in with another user and trying to select from some
>> tables , showing this message :
>>=20
>> ERROR: =A0catalog is missing 11 attribute(s) for relid 113971
>>=20
>> Could you help us to solve this=A0problem? or could you give contact who
>> can help with=A0this?
>=20
> Do you have space to back up the $DATADIR or do you have a recent backup?
>=20
> Asking because that would be helpful before you try the below.
>=20
> I would take a look at:
> https://www.postgresql.org/docs/12/sql-reindex.html

That's a bad data corruption pattern, and rolling in a backup is
recommended (make sure that they are actually safe to use!).  A
REINDEX should help you to retrieve data and move it somewhere else if
you don't have a backup, but nothing more as there is no guarantee
that other parts of the system are not broken.  As others have already
pointed out, take the time necessary to read that:
https://wiki.postgresql.org/wiki/Corruption

But first, you should take three, slow, deep breaths.  Rushing can
only make things worse.
--
Michael

--vs0rQTeTompTJjtd
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl4efqoACgkQnvQgOdby
QH0w8hAAgbiPSBms4z+XywW7HII3O5INubhnHViDYuzM4FuQ9Mz8rkO+R4fg1TUA
5Hch5aRnxAMTUGoe6f+Us9piraJNfS853pHkrwSCUGC+A47d2RmCQ2qzfVTbeTqs
BybxnsD6GaaA9NOfiVZR4Z8NmrfDqrS828lG/cSNpV6zMj+S9adQOnpYgI5wKc0U
0YZBo4KAf3oOpB3HImYVc+QnUVxzla1SPnaJpdTheZn+DkVJh//yCh3JxH/prOKI
XNqaIFzt7xykT/t7x3i/ev8jS84UOQOJJk6IaCrLuP7LOni4FrjsHWI4eTlClh+P
rkI+40J9kwTLrtXhgC0TvB9FOjrCbWgYoxe3mdG25gTAns2wyN2ARGKAVv/w787+
YuCVN3CDV48UNOnXeTOceA5kEIYPeJfRF0as/w3Oi00Gk5U8o+O2RD8hGddv6zxm
RPw3oj6lq/XC/2pI+5hnEFj1wc3gRWrX1VM8ZO/jGcVOqHX1EnhvytVT3Zlmgbrt
+62FFdZ3tDmmGHKVw9iVMCgTph5K/1aAiDs0WoJo8cxEwOK2fUc85QfxxpPMY1z2
XzbM9N5ROo1daAdhtdGdx8gpRTVQpmy0bJkPoL59IpbaQ/3AXQosmhNWxBRWYm42
9k89HwTqi5KF+FhHgKzKJB/zZqJg90mg+dXMeiLL3bp5n6xa1ys=
=YgFW
-----END PGP SIGNATURE-----

--vs0rQTeTompTJjtd--