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