On Fri, February 19, 2021 13:30, David G. Johnston wrote:
> On Fri, Feb 19, 2021 at 11:22 AM James B. Byrne <byrnejb@xxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxx
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
