Feedback-ID: i6d194797:Fastmail
Message-ID: <7429705a-e70f-03d5-9ef3-c60d86d65786@fastmail.com.au>
Date: Sun, 26 Mar 2023 10:06:03 +1100
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.9.0
Subject: Re: Debian PostgreSQL 15 pg_createcluster - could not open collator
 for locale
Content-Language: en-AU
To: Erik Wienhold <ewie@ewie.name>
References: <93809259-173b-9bf0-acb8-d6e0b5c06b87@fastmail.com.au>
 <1684230080.452693.1679762358599@office.mailbox.org>
From: Matt Gibbins <matt_gibbins@fastmail.com.au>
Cc: pgsql-admin@lists.postgresql.org
In-Reply-To: <1684230080.452693.1679762358599@office.mailbox.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/7429705a-e70f-03d5-9ef3-c60d86d65786%40fastmail.com.au>
Precedence: bulk

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@fastmail.com.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