From: | Matt Gibbins <matt_gibbins(at)fastmail(dot)com(dot)au> |
---|---|
To: | Erik Wienhold <ewie(at)ewie(dot)name> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale |
Date: | 2023-03-25 23:06:03 |
Message-ID: | 7429705a-e70f-03d5-9ef3-c60d86d65786@fastmail.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Erik
Thanks.
The version currently installed as identified from dpkg -l is.
Desired=Unknown/Install/Remove/Purge/Hold
|
Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Architecture Description
+++-==============-============-============-====================================
ii libicu67:amd64 67.1-7 amd64 International Components
for Unicode
The ls command returns.
lrwxrwxrwx 1 root root 18 Jul 1 2021
/usr/lib/x86_64-linux-gnu/libicudata.so.67 -> libicudata.so.67.1
-rw-r--r-- 1 root root 28407344 Jul 1 2021
/usr/lib/x86_64-linux-gnu/libicudata.so.67.1
lrwxrwxrwx 1 root root 18 Jul 1 2021
/usr/lib/x86_64-linux-gnu/libicui18n.so.67 -> libicui18n.so.67.1
-rw-r--r-- 1 root root 3160560 Jul 1 2021
/usr/lib/x86_64-linux-gnu/libicui18n.so.67.1
lrwxrwxrwx 1 root root 16 Jul 1 2021
/usr/lib/x86_64-linux-gnu/libicuio.so.67 -> libicuio.so.67.1
-rw-r--r-- 1 root root 55456 Jul 1 2021
/usr/lib/x86_64-linux-gnu/libicuio.so.67.1
lrwxrwxrwx 1 root root 18 Jul 1 2021
/usr/lib/x86_64-linux-gnu/libicutest.so.67 -> libicutest.so.67.1
-rw-r--r-- 1 root root 81400 Jul 1 2021
/usr/lib/x86_64-linux-gnu/libicutest.so.67.1
lrwxrwxrwx 1 root root 16 Jul 1 2021
/usr/lib/x86_64-linux-gnu/libicutu.so.67 -> libicutu.so.67.1
-rw-r--r-- 1 root root 211880 Jul 1 2021
/usr/lib/x86_64-linux-gnu/libicutu.so.67.1
lrwxrwxrwx 1 root root 16 Jul 1 2021
/usr/lib/x86_64-linux-gnu/libicuuc.so.67 -> libicuuc.so.67.1
-rw-r--r-- 1 root root 1988784 Jul 1 2021
/usr/lib/x86_64-linux-gnu/libicuuc.so.67.1
Information obtained from 'apt-cache policy libicu67'.
libicu67:
Installed: 67.1-7
Candidate: 67.1-7
Version table:
*** 67.1-7 500
500 http://mirror.linux.org.au/debian bullseye/main amd64 Packages
100 /var/lib/dpkg/status
Matt
On 26/3/23 03:39, Erik Wienhold wrote:
>> On 25/03/2023 01:55 CET Matt Gibbins <matt_gibbins(at)fastmail(dot)com(dot)au> wrote:
>>
>> I am having trouble with a fresh installation of PostgreSQL 15 from the apt
>> repository 'http://apt.postgresql.org/pub/repos/apt bullseye-pgdg main'.
>> After installing the packages the following locations were empty:
>> * /etc/postgresql/15/main/
>> * /var/lib/postgresql/
>> Searching for information suggested running 'sudo pg_createcluster 15 main --start'
>> to initialise the database.
>> The process failed with the message 'could not open collator for locale "yue-Hans"'.
>>
>> Following is the stdout for the process. Any suggestions welcome
>> Matt.
>>
>> ------------------------------
>> Creating new PostgreSQL cluster 15/main ...
>> /usr/lib/postgresql/15/bin/initdb -D /var/lib/postgresql/15/main --auth-local peer --auth-host scram-sha-256 --no-instructions
>> The files belonging to this database system will be owned by user "postgres".
>> This user must also own the server process.
>>
>> The database cluster will be initialized with locale "en_AU.UTF-8".
>> The default database encoding has accordingly been set to "UTF8".
>> The default text search configuration will be set to "english".
>>
>> Data page checksums are disabled.
>>
>> fixing permissions on existing directory /var/lib/postgresql/15/main ... ok
>> creating subdirectories ... ok
>> selecting dynamic shared memory implementation ... posix
>> selecting default max_connections ... 100
>> selecting default shared_buffers ... 128MB
>> selecting default time zone ... Australia/Canberra
>> creating configuration files ... ok
>> running bootstrap script ... ok
>> performing post-bootstrap initialization ... 2023-03-25 11:50:31.124 AEDT [12104] FATAL: could not open collator for locale "yue-Hans": U_INVALID_FORMAT_ERROR
>> 2023-03-25 11:50:31.124 AEDT [12104] STATEMENT: SELECT pg_import_system_collations('pg_catalog');
>>
>> child process exited with exit code 1
>> initdb: removing contents of data directory "/var/lib/postgresql/15/main"
>> Error: initdb failed
> Looks like an issue with libicu. What version is installed?
>
> dpkg -l 'libicu*'
> ls -l /usr/lib/x86_64-linux-gnu/libicu*
>
> --
> Erik
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Wienhold | 2023-03-26 04:30:06 | Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale |
Previous Message | Erik Wienhold | 2023-03-25 16:39:18 | Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale |