|
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@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 |
