> On 25/03/2023 01:55 CET Matt Gibbins <matt_gibbins@xxxxxxxxxxxxxxx> 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
