| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | unilynx <unilynx(at)gmail(dot)com> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Index created with PGSQL11 on ubuntu 18.04 corrupt with PGSQL11 on ubuntu 20.04 |
| Date: | 2021-02-02 10:22:00 |
| Message-ID: | CABUevEzrZGav4RZ1kWGqu1d9Hc5Hu5Q_k9RPCoAGQaueQ9TwAw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Feb 2, 2021 at 11:20 AM unilynx <unilynx(at)gmail(dot)com> wrote:
>
> I'm using postgresql 11 builds from http://apt.postgresql.org/pub/repos/apt/
> - I've got a database created under Ubuntu 18.04, and recently updated to
> Ubuntu 20.04. These are all docker builds
This is a known problem when upgrading Ubuntu (and most other Linux
distributions, but it depends on which version of course -- btu for
Ubuntu LTS the problem is triggered when going to 20.04). If you have
any indexes on text-type columns, they need to be reindexed.
See https://wiki.postgresql.org/wiki/Locale_data_changes
Note that this is triggered by the Ubuntu upgrade, not by upgrading
PostgreSQL -- that's why it happend even when you keep using the same
PostgreSQL version.
--
Magnus Hagander
Me: https://www.hagander.net/
Work: https://www.redpill-linpro.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | unilynx | 2021-02-02 10:32:55 | Re: Index created with PGSQL11 on ubuntu 18.04 corrupt with PGSQL11 on ubuntu 20.04 |
| Previous Message | Jiří Pavlovský | 2021-02-02 10:11:49 | Re: libpq and mysterious "invalid byte sequence for encoding UTF8". |