Feedback-ID: i6d194797:Fastmail
Content-Type: multipart/alternative;
 boundary="------------ADENinWfNeVHs15dq0Nlk0l7"
Message-ID: <93809259-173b-9bf0-acb8-d6e0b5c06b87@fastmail.com.au>
Date: Sat, 25 Mar 2023 11:55:35 +1100
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.9.0
To: pgsql-admin@lists.postgresql.org
From: Matt Gibbins <matt_gibbins@fastmail.com.au>
Content-Language: en-AU
Subject: Debian PostgreSQL 15 pg_createcluster - could not open collator for
 locale
Archived-At: 
 <https://www.postgresql.org/message-id/93809259-173b-9bf0-acb8-d6e0b5c06b87%40fastmail.com.au>
Precedence: bulk

This is a multi-part message in MIME format.
--------------ADENinWfNeVHs15dq0Nlk0l7
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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

--------------ADENinWfNeVHs15dq0Nlk0l7
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>I am having trouble with a fresh installation of PostgreSQL 15
      from the apt repository '<a class="moz-txt-link-freetext" href="http://apt.postgresql.org/pub/repos/apt">http://apt.postgresql.org/pub/repos/apt</a>
      bullseye-pgdg main'.</p>
    <p>After installing the packages the following locations were empty:</p>
    <ul>
      <li>/etc/postgresql/15/main/</li>
      <li>/var/lib/postgresql/</li>
    </ul>
    <p>Searching for information suggested running 'sudo
      pg_createcluster 15 main --start' to initialise the database.</p>
    <p>The process failed with the message 'could not open collator for
      locale "yue-Hans"'. <br>
    </p>
    <p>Following is the stdout for the process. Any suggestions welcome</p>
    <p>Matt.<br>
    </p>
    <hr width="100%" size="2">
    <p>Creating new PostgreSQL cluster 15/main ...<br>
      /usr/lib/postgresql/15/bin/initdb -D /var/lib/postgresql/15/main
      --auth-local peer --auth-host scram-sha-256 --no-instructions<br>
      The files belonging to this database system will be owned by user
      "postgres".<br>
      This user must also own the server process.<br>
      <br>
      The database cluster will be initialized with locale
      "en_AU.UTF-8".<br>
      The default database encoding has accordingly been set to "UTF8".<br>
      The default text search configuration will be set to "english".<br>
      <br>
      Data page checksums are disabled.<br>
      <br>
      fixing permissions on existing directory
      /var/lib/postgresql/15/main ... ok<br>
      creating subdirectories ... ok<br>
      selecting dynamic shared memory implementation ... posix<br>
      selecting default max_connections ... 100<br>
      selecting default shared_buffers ... 128MB<br>
      selecting default time zone ... Australia/Canberra<br>
      creating configuration files ... ok<br>
      running bootstrap script ... ok<br>
      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<br>
      2023-03-25 11:50:31.124 AEDT [12104] STATEMENT:  SELECT
      pg_import_system_collations('pg_catalog');<br>
          <br>
      child process exited with exit code 1<br>
      initdb: removing contents of data directory
      "/var/lib/postgresql/15/main"<br>
      Error: initdb failed<br>
    </p>
  </body>
</html>

--------------ADENinWfNeVHs15dq0Nlk0l7--