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: [EMAIL PROTECTED] 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
