On Fri, 2024-03-22 at 13:41 +0530, Daulat wrote:
> We are unable to take the backup of our database. While taking backup we are getting the same error.
>
> psql: error: connection to server at "localhost" (::1), port 5014 failed: FATAL: pg_attribute catalog is missing 1
attribute(s)for relation OID 2662
Then you got severe data corruption. This is the index "pg_class_oid_index",
and corrupted metadata make recovery difficult.
If I were you, I would seek professional help.
But first, stop working with this database immediately.
Stop the server and take a backup of all the files in the data
directory.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com