Re: Loss of table structure on 7.3.19

Nigel Metheringham <nigel.metheringham@dev.intechnology.co.uk> 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