Our template 0 database has an XID issue:
postgres=# select datname, age(datfrozenxid) from pg_database;
datname | age
--------------+------------
postgres | 1073965753
.
.
.
template1 | 1073892377
template0 | 2146706522
(7 rows)
When we try a vacuum full, it skips template 0:
[root(at)p02c06d130 mxl]# /mxl/var/pgsql/bin/vacuumdb -a -z -U postgres
vacuumdb: vacuuming database "postgres"
VACUUM
.
.
.
VACUUM
vacuumdb: vacuuming database "template1"
VACUUM
Suggestions for how to fix this issue?
Thanks,
Keaton