Search Postgresql Archives

Re: ERROR: catalog is missing 3 attribute(s) for relid 150243

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

 



milist ujang <ujang.milist@xxxxxxxxx> writes:
> On Fri, Aug 19, 2022 at 11:02 AM Julien Rouhaud <rjuju123@xxxxxxxxx> wrote:
>> What it means is that you likely have data corruption.  You could try
>> to reindex pg_attribute and see if that fixes that specific problems,
>> but even if it does you will have to investigate how data got
>> corrupted, fix that root problem, and then try to check for other
>> corrupted data or restore from a sane backup.

> yes we have a problem with vm; suddenly restart without reason....

Ugh.

> I've done reinding pg_class, pg_attribute, pg_constraint without luck.

That was your only chance of an easy way out :-(.  At this point you
clearly have data corruption in one or more system catalogs, and there's
no particular reason to think that the damage is only in the catalogs
and not also in your user-data tables.

If the data is worth a substantial amount of money to you, I'd recommend
hiring a professional Postgres support company with experience in data
recovery.  You can find some links here:
https://www.postgresql.org/support/professional_support/

Otherwise, restore from your latest backup, and resolve to get better
at keeping backups, and ask some hard questions about the reliability
of the storage stack you're sitting on.

			regards, tom lane





[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 Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux