Re: Loss of table structure on 7.3.19 - Mailing list pgsql-admin

From Tom Lane
Subject Re: Loss of table structure on 7.3.19
Date
Msg-id 10357.1253197836@sss.pgh.pa.us
Whole thread Raw
In response to Re: Loss of table structure on 7.3.19  (Nigel Metheringham <nigel.metheringham@dev.intechnology.co.uk>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Nigel Metheringham
Date:
Subject: Re: Loss of table structure on 7.3.19
Next
From: Ron Mayer
Date:
Subject: Re: hardware information