Re: PKEY getting corrupted

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: PKEY getting corrupted
Дата
Msg-id 20200910133417.GA24518@alvherre.pgsql
обсуждение исходный текст
Ответ на PKEY getting corrupted  ("Abraham, Danny" <danny_abraham@bmc.com>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: PKEY getting corrupted
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: PG13 partitioned table logical replication