tomas(at)tuxteam(dot)de (Tomas Zerolo) writes:
> - What is the nevironment of the server process? That is: what does the
> shell command 'locale' say when it is issued in the same environment
> as the server starts? (that is not necessarily the environment you get
> if you start a shell!). Try, e.g. putting ''export LANG=us_US.UTF-8''
> just before the server is called (typically in /etc/init.d/postgresql
> or thereabout.
In recent PG versions you can do SHOW LC_COLLATE and/or SHOW LC_CTYPE
to verify the locale settings the server is using. Note that these are
locked down based on the environment seen by initdb --- you can't change
them just by inserting an environment setting into the postmaster start
script.
regards, tom lane