Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12

Поиск
Список
Период
Сортировка
От Kristjan Mustkivi
Тема Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12
Дата
Msg-id CAOQPKaut-MBc6Z5q9ZasBwtgOXpRO7AR+QzNeuwMt-4-pZTLSA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Ответы Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12  (Ron <ronljohnsonjr@gmail.com>)
Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Список pgsql-general
On Thu, Oct 27, 2022 at 12:18 PM Peter J. Holzer <hjp-pgsql@hjp.at> wrote:
>
> On 2022-10-27 10:55:31 +0300, Kristjan Mustkivi wrote:
> > We use dockerized postgres.
>
> So that means you aren't just replacing PostgreSQL, but your complete OS
> (except the kernel). What is the source of your docker images? Do they
> all use the same base OS distribution? Are the locale definitions the
> same?
>
> (Just trying to rule other other possible error sources.)

Hello!

Up until 11.17, the source of the docker images was tag "postgres:11"
(from https://hub.docker.com/_/postgres), for 11.17 the tag became
"postgres:11-bullseye" but as far as i could tell it was just a
difference of tagging policy there. Everything else is kept the same
when building our custom docker image (with pg_cron, wal2json and
oracle_fdw). But.. I can see for example, that the PG 11.12 docker
image used Debian 9.13 (PG 11.17 uses Debian 11.5 according to
/etc/debian_version). So the official docker images also upgrade the
OS (which is expected I suppose).

Best regards,
-- 
Kristjan Mustkivi

Email: kristjan.mustkivi@gmail.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Allan Kamau
Дата:
Сообщение: Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Value Too long varchar(100)