Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent - Mailing list pgsql-general

From David G. Johnston
Subject Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent
Date
Msg-id CAKFQuwb+i33wj=KKzYCd2YgMgvgK37EGpHC-PKQ1BYxbkCnVHA@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent  (FOUTE K. Jaurès <jauresfoute@gmail.com>)
List pgsql-general
On Wed, Sep 1, 2021 at 8:29 AM FOUTE K. Jaurès <jauresfoute@gmail.com> wrote:
I already restart the server (x3)


Ok.  During server startup (or shutdown for that matter) are there any warnings or errors in the log file?  Is there anything in the server logs from around the time this started to occur?

You haven't commented on the contents of the catalogs being accurate or not yet.  Assuming they are not (seems likely) I'd say the decision is about how much effort to spend figuring out why they are incorrect versus just restoring from backups (you can/should save the PostgreSQL installation and data once the server is shutdown).

WAL may provide some clues if continued research is needed (in addition to whatever logs or other data you collect) though that is not an area I am practiced in.

David J.

pgsql-general by date:

Previous
From: FOUTE K. Jaurès
Date:
Subject: Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent