Re: Default locale in postgres

From: Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Default locale in postgres
Date: 2018-07-14 06:10:21
Message-ID: CAF6DVKMRGe9Pa8=f-_ksgo0MLQGtRBCXe4NsUyaESk0aq2U64A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Debraj Manna <subharaj(dot)manna(at)gmail(dot)com> writes:
> > Thanks Tom for replying.
> > support(at)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
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2018-07-14 07:30:19 Re: Default locale in postgres
Previous Message Tom Lane 2018-07-13 20:57:39 Re: Default locale in postgres