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

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(dot)vondra(at)2ndquadrant(dot)com>
Sent: Thursday, July 04, 2019 10:18 PM
To: Kumar, Pawan (Nokia - IN/Bangalore) <pawan(dot)kumar(at)nokia(dot)com>
Cc: andres(at)2ndquadrant(dot)com; andrew(at)dunslane(dot)net; josh(at)agliodbs(dot)com; pgsql-hackers(at)postgresql(dot)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 running currently.
>
>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