From: James B. Byrne <byrnejb@harte-lyne.ca>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: --locale options not honoured?
Date: Fri, 19 Feb 2021 14:14:48 -0500
Message-ID: <ddd633113414c2103e39bb1e42513c74.squirrel@webmail.harte-lyne.ca> (raw)
In-Reply-To: <CAKFQuwZr7Etw6+G_pJ5Yxfih6kOaMLNx9DMfp7a66dFpq9aZbQ@mail.gmail.com>
References: <a699fbd83ba356eca4d7164a833ab1dc.squirrel@webmail.harte-lyne.ca>
<CAKFQuwZr7Etw6+G_pJ5Yxfih6kOaMLNx9DMfp7a66dFpq9aZbQ@mail.gmail.com>
On Fri, February 19, 2021 13:30, David G. Johnston wrote:
> On Fri, Feb 19, 2021 at 11:22 AM James B. Byrne <byrnejb@harte-lyne.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.
>
. . .
> 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.
>
I do not know how I did that but, evidently I did. Thank you.
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 | 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 | =c/postgres
+
| | | | |
postgres=CTc/postgres
(3 rows)
--
*** 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, david.g.johnston@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: --locale options not honoured?
In-Reply-To: <ddd633113414c2103e39bb1e42513c74.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