| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | FOUTE K(dot) Jaurès <jauresfoute(at)gmail(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent |
| Date: | 2021-09-01 15:40:03 |
| Message-ID: | CAKFQuwb+i33wj=KKzYCd2YgMgvgK37EGpHC-PKQ1BYxbkCnVHA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Sep 1, 2021 at 8:29 AM FOUTE K. Jaurès <jauresfoute(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-09-01 15:46:41 | Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent |
| Previous Message | FOUTE K. Jaurès | 2021-09-01 15:35:18 | Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent |