Erwin Brandstetter wrote:
> I've been reading tons of stuff on locale and postgresql. I am still
> not in the clear about some details, though: how do system locale and
> database locale work together (or not)?
The system locale is more or less ignored. What matters are the locales
set in the database.
> If I am running a database cluster with --encoding= UTF8, are there
> any troubles to be expected if the system locale remains "C" or
> somehting like "de_AT.iso885915@euro"?
Your sort order will approach randomness.
> Is it enough to have an UTF8 locale installed on the system?
You need to have it installed and you need to tell initdb to use it.
> Or does it actually have to be the system locale?
No.
> Do multiple UTF8 system locales have any effect?
No.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/