Debian PostgreSQL 15 pg_createcluster - could not open collator for locale - Mailing list pgsql-admin

From Matt Gibbins
Subject Debian PostgreSQL 15 pg_createcluster - could not open collator for locale
Date
Msg-id 93809259-173b-9bf0-acb8-d6e0b5c06b87@fastmail.com.au
Whole thread Raw
Responses Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale  (Erik Wienhold <ewie@ewie.name>)
List pgsql-admin

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

pgsql-admin by date:

Previous
From: Sbob
Date:
Subject: Re: PL/pgSQL function to run DDL on a remote server/cluster?
Next
From: Erik Wienhold
Date:
Subject: Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale