Search Postgresql Archives

Re: Mixed Locales and Upgrading

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Adrian Klaver <adrian.klaver@xxxxxxxxxxx> writes:
> On 4/29/20 1:10 PM, Don Seiler wrote:
>> On Tue, Apr 7, 2020 at 11:41 AM Don Seiler <don@xxxxxxxxx 
>> <mailto:don@xxxxxxxxx>> wrote:
>> Since I'm not changing the postgres or template0 databases (leaving 
>> those as en_US/LATIN1), do I keep lc_collate/lc_ctype as en_US? It's 
>> just the template1 and application database that I've set to en_US.UTF-8.

I believe that those settings only affect locale-dependent processing
in the postmaster and/or background processes, which there should be
little or none of anyway.  Processes connected to specific databases will
adopt the settings defined for those databases.

>> I'm also struggling to see how lc_messages is an empty string. It is 
>> commented out in postgresql.conf but suggests 'C' will be the default. 

> Are you sure?:
>      Sets the language in which messages are displayed. Acceptable 
> values are system-dependent; see Section 23.1 for more information. If 
> this variable is set to the empty string (which is the default) then the 
> value is inherited from the execution environment of the server in a 
> system-dependent way. ..."

The "system-dependent way" is "adopt whatever the LANG/LC_foo environment
variables say at server startup", at least on non-Windows machines.
I think that C is the fallback if none of those variables are set, though.

Short answer is you shouldn't need to mess with these.

			regards, tom lane





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux