Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen

2024-03-22 Thread Laurenz Albe
On Fri, 2024-03-22 at 16:07 +0530, Vijaykumar Jain wrote: > On Fri, 22 Mar 2024 at 15:39, Laurenz Albe wrote: > > 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: e

Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen

2024-03-22 Thread Vijaykumar Jain
On Fri, 22 Mar 2024 at 15:39, Laurenz Albe wrote: > 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

Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen

2024-03-22 Thread Laurenz Albe
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 re

Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen

2024-03-22 Thread Daulat
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 Lau

Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen

2024-03-22 Thread Laurenz Albe
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 e