Re: emergency outage requiring database restart

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: emergency outage requiring database restart
Дата
Msg-id CACjxUsPZoYyNthWHMfqHB4Ck7QMfbx=vuvNLMDTZggLtVds25g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: emergency outage requiring database restart  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: emergency outage requiring database restart  (Merlin Moncure <mmoncure@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: [RFC] Transaction management overhaul is necessary?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Default setting for autovacuum_freeze_max_age