Re: Loss of table structure on 7.3.19

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

 



Nigel Metheringham <nigel.metheringham@xxxxxxxxxxxxxxxxxxxxxx> writes:
> On 17 Sep 2009, at 14:57, Tom Lane wrote:
>> The symptoms indicate pretty strongly that you forgot about vacuuming
>> the system catalogs.  A plain "VACUUM" executed in every database, by
>> a superuser, is sufficient for this.  Trying to be smart by vacuuming
>> only what you think needs vacuumed is not sufficient.

> By "in every database" do you mean we need to vacuum the template*
> databases too?

All the connectable databases, I believe is the rule (although 7.4
was so long it might have done things differently).

			regards, tom lane

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[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