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