Template zero xid issue

From: "Keaton Adams" <kadams(at)mxlogic(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Template zero xid issue
Date: 2007-08-06 15:44:02
Message-ID: 0B34A6972BF39E4CB465A64DBBAD2BB902261D09@mxlhq-exch01.corp.mxlogic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-08-06 15:50:53 Re: Template zero xid issue
Previous Message Tom Lane 2007-08-06 15:31:51 Re: [PERFORM] Planner making wrong decisions 8.2.4. Insane cost calculations.