Re: Index corruption

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Index corruption
Дата
Msg-id CAOR=d=08e2CpTiZcmxiN+kXf7Pt+5b553TntguXSvFZ0dVjU+A@mail.gmail.com
обсуждение исходный текст
Ответ на Index corruption  (Bankim Bhavsar <bankim@nimblestorage.com>)
Список pgsql-general
On Tue, Mar 24, 2015 at 12:49 PM, Bankim Bhavsar
<bankim@nimblestorage.com> wrote:
> Hello postgres experts,
>
> We are running a test that periodically abruptly kills postgres
> process(equivalent to kill -9) and restarts it.
> After running this test for 24 hrs or so, we see duplicate primary key
> entries in postgres table.
>

Are you killing the POSTMASTER process, deleting the pid file, and
then restarting it without killing its children? That's a recipe for
corruption.


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

Предыдущее
От: Deven Phillips
Дата:
Сообщение: Re: JSON "pretty" and selecting nested JSON fields
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Muti-table join and roll-up aggregate data into nested JSON?