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 Thanks. On Fri, Mar 22, 2024 at 12:35 PM Laurenz Albe <laurenz.a...@cybertec.at> wrote: > On Fri, 2024-03-22 at 10:56 +0530, Daulat wrote: > > We recently started seeing an error “ERROR: uncommitted xmin 3100586 > > from before xid cutoff 10339367 needs to be frozen” on our user tables. > > I’m unable to do ‘vacuum’, ‘vacuum freeze’ or ‘vacuum full’ on Postgres > 14.4 running on a windows environment. > > > > Error: > > > > first come this---- ERROR: uncommitted xmin 3100586 from before xid > cutoff 10339367 needs to be frozen > > CONTEXT: while scanning block 1403 offset 8 of relation > "pg_catalog.pg_attribute" > > Update to 14.latest; perhaps that data corruption was caused by a bug that > is already fixed. > > Upgrading won't get rid of the error though (I think). > The seasy way is to dump the database and restore it to a new database. > > Yours, > Laurenz Albe >
