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
t 12:35 PM Laurenz Albe 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 freez

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

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

2024-03-21 Thread Daulat
Hi All, 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