collation "case_insensitive" has version mismatch

Article View: pl.comp.bazy-danych

Article #195782

Back to pl.comp.bazy-danych Previous Next

#195782

From: Maciej Browarski
Date: Wed, 05 Oct 2022 15:27

16 lines
2242 bytes

Cześć,
Mam serwer master na Ubuntu 16 z postgreSQL 12, robię replikację na serwer slave Ubuntu 20 z postgreSQL 12. Replikacja działa, widzę dane na slave, niestety mam jedną kolumnę zdefiniowaną jako: 
name character varying(10) COLLATE public.case_insensitive
collate zrobione jako:
CREATE COLLATION public.case_insensitive (provider = icu, deterministic = false, locale = 'und-u-ks-level2');

niestety, otrzymuję błąd przy selectach:
WARNING:  collation "case_insensitive" has version mismatch
DETAIL:  The collation in the database was created using version 153.56, but the operating system provides version 153.14.
HINT:  Rebuild all objects affected by this collation and run ALTER COLLATION public.case_insensitive REFRESH VERSION, or build PostgreSQL with the right library version.

Czy to jest kwestia ICU (na ubuntu 16: libicu55, na ubuntu 20: libicu66) czy jakieś brakującego pliku z definicjami?

Ktoś może wie, jak wyciągnąć wersje tych collation (153.14 i 153.56) z linux?

Pozdrawiam

Technical Details

Message-ID: <285ee2bf-f40c-4798-91eb-7ecb92e82035n@googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.man.lodz.pl!newsfeed.pionier.net.pl!3.eu.feeder.erje.net!feeder.erje.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Received: by 2002:a05:622a:64b:b0:35d:5860:ea86 with SMTP id a11-20020a05622a064b00b0035d5860ea86mr85451qtb.277.1664983670215;        Wed, 05 Oct 2022 08:27:50 -0700 (PDT)
X-Received: by 2002:a05:622a:190:b0:35d:4803:4303 with SMTP id s16-20020a05622a019000b0035d48034303mr83301qtw.253.1664983669968; Wed, 05 Oct 2022 08:27:49 -0700 (PDT)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.man.lodz.pl!newsfeed.pionier.net.pl!3.eu.feeder.erje.net!feeder.erje.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: pl.comp.bazy-danych
Date: Wed, 5 Oct 2022 08:27:49 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=194.15.121.24; posting-account=48M0fAoAAADrlvklAmYgv7VB6pLtxu_5
NNTP-Posting-Host: 194.15.121.24
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <285ee2bf-f40c-4798-91eb-7ecb92e82035n@googlegroups.com>
Subject: collation "case_insensitive" has version mismatch
From: Maciej Browarski <maciej.browarski@gmail.com>
Injection-Date: Wed, 05 Oct 2022 15:27:50 +0000
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit