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

From Nigel Metheringham
Subject Re: Loss of table structure on 7.3.19
Date
Msg-id DF98BF90-E7C8-4041-B9EF-9DA29A62E72C@dev.intechnology.co.uk
Whole thread Raw
In response to Re: Loss of table structure on 7.3.19  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Loss of table structure on 7.3.19  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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@InTechnology.com ]
[ - Comments in this message are my own and not ITO opinion/policy - ]


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Loss of table structure on 7.3.19
Next
From: Tom Lane
Date:
Subject: Re: Loss of table structure on 7.3.19