Debraj Manna <subharaj.manna@xxxxxxxxx> 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