Postgres Pro
Downloads
Home   >   mailing lists

Template zero xid issue - Mailing list pgsql-general

From Keaton Adams
Subject Template zero xid issue
Date
Msg-id 0B34A6972BF39E4CB465A64DBBAD2BB902261D09@mxlhq-exch01.corp.mxlogic.com
Whole thread Raw
Responses Re: Template zero xid issue  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view

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

 

 

 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PERFORM] Planner making wrong decisions 8.2.4. Insane cost calculations.
Next
From: Tom Lane
Date:
Subject: Re: Template zero xid issue