Re: Loss of table structure on 7.3.19

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

 




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?

[and I'm just thankful, that as major wake up calls go, this was only
painful as opposed to fatal or permanently debilitating!]

	Nigel.
--
[ Nigel Metheringham             Nigel.Metheringham@xxxxxxxxxxxxxxxx ]
[ - Comments in this message are my own and not ITO opinion/policy - ]


--
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