Re: --locale options not honoured?

On Fri, Feb 19, 2021 at 11:22 AM James B. Byrne <byrnejb(at)harte-lyne(dot)ca>
wrote:

> I am try to create a new pg database with --locale=en_US.UTF8.

You are creating a whole new cluster., not just a database.

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
>
>
> 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)
>
>
You created a new cluster, but never started it, yet were able to connect
to it without a problem. I suspect you are connecting psql to some already
running existing cluster and that the cluster you initdb'd is correctly
configured but just sitting there offline waiting to be started - possibly
after changing its port information so it doesn't conflict with this
already running instance.

David J.