From: Tom Lane <tgl@sss.pgh.pa.us>
To: Debraj Manna <subharaj.manna@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Default locale in postgres
Date: Fri, 13 Jul 2018 16:57:39 -0400
Message-ID: <10739.1531515459@sss.pgh.pa.us> (raw)
In-Reply-To: <CAF6DVKNho8jr=poGgEnvOcgfV_Ma0kYrKBgEsQWRYKMt3cSu0Q@mail.gmail.com>
References: <CAF6DVKOwLjB43apk3-uiCOS9FNt+wSPm=RR4EvUMpQhhiQ4tWQ@mail.gmail.com>
<773.1531506368@sss.pgh.pa.us>
<CAF6DVKNho8jr=poGgEnvOcgfV_Ma0kYrKBgEsQWRYKMt3cSu0Q@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, subharaj.manna@gmail.com
Subject: Re: Default locale in postgres
In-Reply-To: <10739.1531515459@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox