Re: Database OID xxxxx now seems to belong to "foo"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Database OID xxxxx now seems to belong to "foo"
Date: 2008-03-11 15:09:37
Message-ID: 20319.1205248177@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> writes:
> I tried vacuum pg_database, no luck. I shut down and restarted the DB
> and it seems to have fixed the problem. Still, not sure why it happened
> in the first place or how to prevent it in the future.

My recollection is that that's a symptom of lack of vacuuming, in PG
versions that are too old to have automatic defenses against such
DBA misfeasance. Check whether your routine vacuuming procedures
cover the system catalogs...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2008-03-11 15:12:31 Re: Database OID xxxxx now seems to belong to "foo"
Previous Message Gurjeet Singh 2008-03-11 14:10:39 Re: ISO something like "#if 0 ... #endif" for SQL code