John Sidney-Woollett <johnsw@xxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
