Re: PKEY getting corrupted

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PKEY getting corrupted
Date: 2020-09-10 13:34:17
Message-ID: 20200910133417.GA24518@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Danny,

On 2020-Sep-10, Abraham, Danny wrote:

> We have seen several times a situation where a PKEY is compromised and
> duplicate values are created within a table.

Yeah, this is not unheard of.

> This has happened so far on PG 928 on Linux and Windows, and also on
> PG955 on AIX.

You do realize that 9.2.8 is not only missing the many bugfixes that
happened until 9.2.24 was released in November 2017, but also any
bugfixes that were done after that branch was abandoned?

9.5.5 sounds more interesting as a target, but it's still missing all
updates until 9.5.23 released last month.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2020-09-10 15:03:43 Re: PG13 partitioned table logical replication
Previous Message Adrian Klaver 2020-09-10 13:28:54 Re: PKEY getting corrupted