Re: Default locale in postgres

Debraj Manna <subharaj.manna@gmail.com> writes:
> Can someone let me know if I am not passing any locale while doing initdb
> what locale (Collate & Ctype) will postgres 9.5.4 pick?

Whatever is the prevailing default in initdb's environment ---
see LANG and LC_XXX environment variables.

If none of those are set, I imagine it'll fall back to C locale,
though this choice is possibly dependent on your local libc.
"man locale" might be informative.

            regards, tom lane