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