On Tue, Mar 24, 2015 at 12:49 PM, Bankim Bhavsar <bankim@xxxxxxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general