RE: duplicate key entries for primary key -- need urgent help

2019-07-04 Thread Kumar, Pawan (Nokia - IN/Bangalore)
(Nokia - IN/Bangalore) Cc: and...@2ndquadrant.com; and...@dunslane.net; j...@agliodbs.com; pgsql-hack...@postgresql.org Subject: Re: duplicate key entries for primary key -- need urgent help On Thu, Jul 04, 2019 at 01:37:01PM +, Kumar, Pawan (Nokia - IN/Bangalore) wrote: >Hi Guys, > >Can you p

Re: duplicate key entries for primary key -- need urgent help

2019-07-04 Thread Kumar, Pawan (Nokia - IN/Bangalore)
...@2ndquadrant.com; and...@dunslane.net; j...@agliodbs.com; pgsql-hack...@postgresql.org Subject: Re: duplicate key entries for primary key -- need urgent help On Thu, Jul 04, 2019 at 05:34:21PM +, Kumar, Pawan (Nokia - IN/Bangalore) wrote: >Thanks a lot Tomas for the reply. > >Which versio

Re: duplicate key entries for primary key -- need urgent help

2019-07-04 Thread Tomas Vondra
On Thu, Jul 04, 2019 at 06:28:03PM +, Kumar, Pawan (Nokia - IN/Bangalore) wrote: Thanks for reply. This has happened very often and at different production system. There is no version change. System running with same version since 1 year but duplicate key issue came quiet a time. And impac

Re: duplicate key entries for primary key -- need urgent help

2019-07-04 Thread Tomas Vondra
On Thu, Jul 04, 2019 at 05:34:21PM +, Kumar, Pawan (Nokia - IN/Bangalore) wrote: Thanks a lot Tomas for the reply. Which version are you running, exactly? Whih minor version? [Pawan]: Its (PostgreSQL) 9.5.9 You're missing 2 years of bugfixes, some of which are addressing data corruption

Re: duplicate key entries for primary key -- need urgent help

2019-07-04 Thread Tomas Vondra
On Thu, Jul 04, 2019 at 01:37:01PM +, Kumar, Pawan (Nokia - IN/Bangalore) wrote: Hi Guys, Can you please help here? Below reported issue in past about duplicate key entries for primary key. https://www.postgresql.org/message-id/534c8b33.9050...@pgexperts.com the solution was provided in 9