Thanks a lot Tomas for the reply.
Which version are you running, exactly? Whih minor version?
[Pawan]: Its (PostgreSQL) 9.5.9
sai=> select version();
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 9.5.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit
(1 row)
Why do you think it's the issue you linked?
[Pawan]: Because the thread which I shared also has problem statement like "Duplicate entries of Primary key" .
If this is also known to this version, I will be appreciating a lot if we have some Workaround or config change.
In our production: See below entries, proc_id is primary key and we can see duplicate entries. How it is possible?
sai=> select ctid,proc_id from etl_status where proc_id='2993229';
ctid | proc_id
----------+---------
(381,20) | 2993229
(388,28) | 2993229
(2 rows)
Any idea, how it happened?
I will waiting for your reply
WBR,
-Pawan
-----Original Message-----
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Sent: Thursday, July 04, 2019 10:18 PM
To: Kumar, Pawan (Nokia - IN/Bangalore) <pawan.kumar@nokia.com>
Cc: andres@2ndquadrant.com; andrew@dunslane.net; josh@agliodbs.com; pgsql-hackers@postgresql.org
Subject: Re: duplicate key entries for primary key -- need urgent help
On Thu, Jul 04, 2019 at 01:37:01PM +0000, 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.9050807@pgexperts.com
>
>the solution was provided in 9.3 version of postgres but it seems issue is still there in 9.5 version which I am
runningcurrently.
>
>Can you please let me know if this is also known in 9.5? any fix or Workaround please?
>
Which version are you running, exactly? Whih minor version?
Why do you think it's the issue you linked?
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services