Re: Default locale in postgres - Mailing list pgsql-admin

From Debraj Manna
Subject Re: Default locale in postgres
Date
Msg-id CAF6DVKMRGe9Pa8=f-_ksgo0MLQGtRBCXe4NsUyaESk0aq2U64A@mail.gmail.com
Whole thread Raw
In response to Re: Default locale in postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Default locale in postgres
List pgsql-admin
Is it possible to specify the default locale in postgres.conf in postgres 10 so that it takes this locale if no locale is specified in initdb?

On Sat, Jul 14, 2018 at 2:27 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Debraj Manna <subharaj.manna@gmail.com> writes:
> Thanks Tom for replying.
> support@vrni-platform-release:~$ locale
> LANG=en_US.UTF-8

OK, so that's what you have in your interactive shell environment ...

> My locale settings are like above. But I am seeing is C picked by postgres.
> Any idea why it is picking C instead of en_US.UTF-8.

Presumably, initdb is not seeing that same environment.  Might be a side
effect of running it under sudo or some wrapper script.

                        regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Default locale in postgres
Next
From: "David G. Johnston"
Date:
Subject: Re: Default locale in postgres