Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] Error accessing catalog table pg_proc - Mailing list pgsql-admin

From Cory Nemelka
Subject [ADMIN] Error accessing catalog table pg_proc
Date
Msg-id CAMe5Gn12H8FWyo3-+H1kbZZu3gafPg2uE2sTn9Xq-ytteToy1w@mail.gmail.com
Whole thread Raw
Responses Re: [ADMIN] Error accessing catalog table pg_proc
List pgsql-admin
Tree view
We are receiving the following error when trying to access pg_proc table:

[local] cnemelka=# \d pg_proc;
ERROR:  XX000: cache lookup failed for attribute 1 of relation 1255
LOCATION:  get_relid_attribute_name, lsyscache.c:807

This error is preventing backups with pg_dump.  It doesn't seem to be affecting the database overall.  We ran VACUUM FULL and REINDEX on the catalog tables but the error persists.

Postgres version is 9.5.7 running on Ubuntu 12.04


Can anyone help?

--cnemelka

pgsql-admin by date:

Previous
From: rammohan ganapavarapu
Date:
Subject: Re: [ADMIN] Can master and slave on different PG versions?
Next
From: George Neuner
Date:
Subject: Re: [ADMIN] Running Windows binaries from non-English folder