Re: low transaction ID wrap limit

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Amiel <jamiel(at)istreamimaging(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: low transaction ID wrap limit
Date: 2007-06-24 15:38:14
Message-ID: 18808.1182699494@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff Amiel <jamiel(at)istreamimaging(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message danmcb 2007-06-24 18:45:00 Re: how to implement unusual constraint
Previous Message Tom Lane 2007-06-24 15:33:36 Re: how to implement unusual constraint