Re: Postgres Server crashed

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Postgres Server crashed
Дата
Msg-id 4E92FB0E0200002500041CE9@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Postgres Server crashed  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Postgres Server crashed  (Akash Kodibail <akash.kodibail@onmobile.com>)
Список pgsql-admin
Scott Marlowe <scott.marlowe@gmail.com> wrote:
> Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
>
>> And normal maintenance may be viewing newer data as old, due to
>> transaction wrap-around from the old pg_control file, and
>> removing it as part of normal cleanup.  So you may have destroyed
>> some of your more recent data by doing that.
>
> At this point, once you have a backup, would you deploy
> pg_resetxlog?

That's what I was thinking.  I shudder to think what autovacuum may
have done while running with the old pg_control file; but I don't
know what else to do at this juncture.

Anyone else have a better idea?

-Kevin

В списке pgsql-admin по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Postgres Server crashed
Следующее
От: Akash Kodibail
Дата:
Сообщение: Re: Postgres Server crashed