Re: low transaction ID wrap limit - Mailing list pgsql-general

From Tom Lane
Subject Re: low transaction ID wrap limit
Date
Msg-id 18808.1182699494@sss.pgh.pa.us
Whole thread Raw
In response to low transaction ID wrap limit  (Jeff Amiel <jamiel@istreamimaging.com>)
List pgsql-general
Jeff Amiel <jamiel@istreamimaging.com> writes:
> I was looking at some logs this morning and spotted this on my backup
> database

> Jun 24 04:08:46 back-app-1 postgres[82445]: [2-1] pgsql 82445 LOG:  transaction ID wrap limit is 41612954, limited by
database"back" 

> Should I be worried?

No.  It's just wrapped past 4 billion.  The age(datfrozenxid) numbers
show you are in good shape; nothing particularly out-of-date except
template0, which doesn't need vacuuming anyway.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: how to implement unusual constraint
Next
From: danmcb
Date:
Subject: Re: how to implement unusual constraint