[GENERAL] Index corruption

2015-03-24 Thread Bankim Bhavsar
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. We detect this as we load internal hash-table data-structur

Re: [GENERAL] Index corruption

2015-03-24 Thread Bankim Bhavsar
Thanks for the input. We'll upgrade to 9.2.10 and attempt to reproduce the issue. If possible, can someone point to corruption related issues fixed after 9.2.0? Thanks, -Bankim. On 03/24/2015 11:56 AM, David G. Johnston wrote: On Tuesday, March 24, 2015, Bankim Bhavsar <ma

Re: [GENERAL] Index corruption

2015-03-29 Thread Bankim Bhavsar
15 12:05 PM, Bankim Bhavsar wrote: >> If possible, can someone point to corruption related issues fixed >> after 9.2.0? > > in the postgres manual, see the release notes for 9.2.1 through 9.2.10 You can find links to those from here: http://www.postgresql.org/docs/9.2/static/re