From: James B. Byrne <byrnejb@harte-lyne.ca>
To: pgsql-admin@lists.postgresql.org
Subject: --locale options not honoured?
Date: Fri, 19 Feb 2021 13:22:13 -0500
Message-ID: <a699fbd83ba356eca4d7164a833ab1dc.squirrel@webmail.harte-lyne.ca> (raw)
FreeBSD 12.2-RELEASE-p3
postgresql13-server-13.1_1
I am try to create a new pg database with --locale=en_US.UTF8. However initdb
does not seem to actually carry out the instructions. I have tried this with
and without the --lc-collate and lc-ctype options. The result is the same.
sudo -u postgres initdb --locale=en_US.UTF-8 --lc-collate=en_US.UTF-8
--lc-ctype=en_US.UTF-8 -D /var/db/postgres/data13
could not change directory to "/root": Permission denied
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_US.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.
creating directory /var/db/postgres/data13 ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Canada/Eastern
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
psql -U postgres template1
psql (13.1)
Type "help" for help.
template1=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+---------+-------+-----------------------
postgres | postgres | UTF8 | C | C |
template0 | postgres | UTF8 | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
(3 rows)
On another (9.6) host I see this:
template1=# \l
List of databases
Name | Owner | Encoding | Collate |
Ctype | Access privileges
---------------------+-----------------------+----------+-------------+-------------+-----------------------
postgres | postgres | UTF8 | en_US.UTF-8 |
en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 |
en_US.UTF-8 | =c/postgres +
| | | |
| postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 |
en_US.UTF-8 | postgres=CTc/postgres+
| | | |
| =c/postgres
Why are not the collating sequence and Ctype set to UTF-8? How do I get the
locale specified completely?
--
*** e-Mail is NOT a SECURE channel ***
Do NOT transmit sensitive data via e-Mail
Unencrypted messages have no legal claim to privacy
Do NOT open attachments nor follow links sent by e-Mail
James B. Byrne mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
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: byrnejb@harte-lyne.ca, pgsql-admin@lists.postgresql.org
Subject: Re: --locale options not honoured?
In-Reply-To: <a699fbd83ba356eca4d7164a833ab1dc.squirrel@webmail.harte-lyne.ca>
* 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