Re: Index corruption - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Index corruption
Date
Msg-id CAOR=d=08e2CpTiZcmxiN+kXf7Pt+5b553TntguXSvFZ0dVjU+A@mail.gmail.com
Whole thread Raw
In response to Index corruption  (Bankim Bhavsar <bankim@nimblestorage.com>)
List 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 by date:

Previous
From: Deven Phillips
Date:
Subject: Re: JSON "pretty" and selecting nested JSON fields
Next
From: Merlin Moncure
Date:
Subject: Re: Muti-table join and roll-up aggregate data into nested JSON?