From: | "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | "Pgsql-admin" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: --locale options not honoured? |
Date: | 2021-02-19 19:14:48 |
Message-ID: | ddd633113414c2103e39bb1e42513c74.squirrel@webmail.harte-lyne.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Fri, February 19, 2021 13:30, David G. Johnston wrote:
> 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.
>
. . .
> 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(at)Harte-Lyne(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Avinash Kumar | 2021-02-19 20:51:57 | Re: Aurora PostgreSQL Support |
Previous Message | Carlos Armijo Severino | 2021-02-19 18:59:24 | Re: Looking find the each row size of table |