Re: Fwd: vacuuming template0 gave ERROR - Mailing list pgsql-admin

From Tom Lane
Subject Re: Fwd: vacuuming template0 gave ERROR
Date
Msg-id 21519.1154309424@sss.pgh.pa.us
Whole thread Raw
In response to Fwd: vacuuming template0 gave ERROR  (adey <adey11@gmail.com>)
Responses Re: Fwd: vacuuming template0 gave ERROR  (adey <adey11@gmail.com>)
List pgsql-admin
adey <adey11@gmail.com> writes:
> select datname, age(datfrozenxid), datfrozenxid, current_date, current_time
> FROM pg_database

> If template0 shouldn't be touched (and I don't know of deliberate access to
> it), why is this changing please?

Because current xid is changing and template0's datfrozenxid is not.

Nonetheless, if template0 is properly frozen then you don't need to
vacuum it, regardless of what age(datfrozenxid) says.

            regards, tom lane

pgsql-admin by date:

Previous
From: adey
Date:
Subject: Fwd: vacuuming template0 gave ERROR
Next
From: adey
Date:
Subject: Re: Fwd: vacuuming template0 gave ERROR