Skip site navigation (1) Skip section navigation (2)

Re: Please HELP - URGENT - transaction wraparound error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John Sidney-Woollett <johnsw(at)wardbrook(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Please HELP - URGENT - transaction wraparound error
Date: 2005-10-30 17:54:52
Message-ID: 12531.1130694892@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
John Sidney-Woollett <johnsw(at)wardbrook(dot)com> writes:
> OK, I restored the pgsql/data to another server and started up postgres
> and this is what I got:

>   SELECT datname, age(datfrozenxid) FROM pg_database;
>     datname    |     age
> --------------+-------------
>   mail_lxtreme | -2074187459
>   bp_live      |  1079895636
>   template1    |  1076578064
>   template0    | -2074187459
> (4 rows)

> mail_lxtreme is a test mail db and I don't care about it. So it could 
> have been deleted without any worries...

> Which databases are a problem? Is it template0 or bp_live and template1?

mail_lxtreme is exactly the problem.  You weren't vacuuming it...

(template0 is a special case and can be ignored.)

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: Nikolay SamokhvalovDate: 2005-10-30 18:24:52
Subject: Oracle 10g Express - any danger for Postgres?
Previous:From: John Sidney-WoollettDate: 2005-10-30 16:51:44
Subject: Re: Please HELP - URGENT - transaction wraparound error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group