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
pgsql-general by date
|Next:||From: Nikolay Samokhvalov||Date: 2005-10-30 18:24:52|
|Subject: Oracle 10g Express - any danger for Postgres?|
|Previous:||From: John Sidney-Woollett||Date: 2005-10-30 16:51:44|
|Subject: Re: Please HELP - URGENT - transaction wraparound error|