Hi,
Recently we faced an issue with postgres server where it is throwing error:
ERROR: catalog is missing 2 attribute(s) for relid 16584
CONTEXT: automatic analyze of table "DBRNW.public.act_wsta"
I checked in the database and found that this table is not present but the
entry for the same is present in 'pg_tables'. This error is occuring when
auto analyze is executed.
I searched for the issue in postgres blogs and found that there is no way
to recover from this situation except restore from last backup!! I wanted
to confirm is there any way to recover at run time? because if we restore
from last backup then we might loose some data that got updated after this
error occurred.
Any help would be appreciated.
--
Thanks,
Prakash