Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@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





[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux