Message-ID: <ddd633113414c2103e39bb1e42513c74.squirrel@webmail.harte-lyne.ca>
In-Reply-To: 
 <CAKFQuwZr7Etw6+G_pJ5Yxfih6kOaMLNx9DMfp7a66dFpq9aZbQ@mail.gmail.com>
References: <a699fbd83ba356eca4d7164a833ab1dc.squirrel@webmail.harte-lyne.ca>
    <CAKFQuwZr7Etw6+G_pJ5Yxfih6kOaMLNx9DMfp7a66dFpq9aZbQ@mail.gmail.com>
Date: Fri, 19 Feb 2021 14:14:48 -0500
Subject: Re: --locale options not honoured?
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>
Reply-To: byrnejb@harte-lyne.ca
User-Agent: SquirrelMail/1.4.23 [SVN]
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Importance: Normal
Precedence: bulk


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