Re: emergency outage requiring database restart - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: emergency outage requiring database restart
Date
Msg-id CACjxUsPZoYyNthWHMfqHB4Ck7QMfbx=vuvNLMDTZggLtVds25g@mail.gmail.com
Whole thread Raw
In response to Re: emergency outage requiring database restart  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: emergency outage requiring database restart  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
On Tue, Oct 18, 2016 at 8:45 AM, Merlin Moncure <mmoncure@gmail.com> wrote:

> Most or all the damage seemed to be to the system catalogs with
> at least two critical tables dropped or inaccessible in some
> fashion.  A lot of the OIDs seemed to be pointing at the wrong
> thing.

While the oid in pg_class often matches the filename, that is not
true after some operations (like CLUSTER or VACUUM FULL).  It is
the relfilenode column that is the definitive link to the file.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: [RFC] Transaction management overhaul is necessary?
Next
From: Bruce Momjian
Date:
Subject: Default setting for autovacuum_freeze_max_age