From: Matt Gibbins <matt_gibbins@fastmail.com.au>
To: pgsql-admin@lists.postgresql.org
Subject: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale
Date: Sat, 25 Mar 2023 11:55:35 +1100
Message-ID: <93809259-173b-9bf0-acb8-d6e0b5c06b87@fastmail.com.au> (raw)
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
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: 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: <93809259-173b-9bf0-acb8-d6e0b5c06b87@fastmail.com.au>
* 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