From: Erik Wienhold <ewie@ewie.name>
To: Matt Gibbins <matt_gibbins@fastmail.com.au>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale
Date: Sat, 25 Mar 2023 17:39:18 +0100 (CET)
Message-ID: <1684230080.452693.1679762358599@office.mailbox.org> (raw)
In-Reply-To: <93809259-173b-9bf0-acb8-d6e0b5c06b87@fastmail.com.au>
References: <93809259-173b-9bf0-acb8-d6e0b5c06b87@fastmail.com.au>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ewie@ewie.name, matt_gibbins@fastmail.com.au, pgsql-admin@lists.postgresql.org
Subject: Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale
In-Reply-To: <1684230080.452693.1679762358599@office.mailbox.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox