Re: PKEY getting corrupted - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: PKEY getting corrupted
Date
Msg-id 20200910133417.GA24518@alvherre.pgsql
Whole thread Raw
In response to PKEY getting corrupted  ("Abraham, Danny" <danny_abraham@bmc.com>)
List 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



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PKEY getting corrupted
Next
From: Peter Eisentraut
Date:
Subject: Re: PG13 partitioned table logical replication