Re: Fwd: vacuuming template0 gave ERROR

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



adey <adey11@xxxxxxxxx> 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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux