Re: initdb with lc-collate=C

On 12/12/2011 12:15 PM, Adrian Klaver wrote:
> On 12/12/2011 10:49 AM, Scot Kreienkamp wrote:
>> Hey guys,
>>
>> In PG 8.x, when I did an initdb with --lc-collate=c it was always
>> effective in setting it server wide so it would apply to all databases.
>> However, in 9.1.2, when I run initdb like so: /etc/init.d/postgresql-9.1
>> initdb --lc-collate=C, it doesn't seem to have any effect.
>>
>> [root(at)dvrv5030 9.1]# psql -U postgres -Aqtc "select setting from
>> pg_settings where name='lc_collate'"
>>
>> en_US.UTF-8
>>
>> Not sure why the difference in behavior. Our application depends on
>> collation being set to C. I can create the individual database with that
>> option, but why won't it stick setting it server-wide with initdb?
>
> Databases are created using template1 as the default template. Did the
> lc_collate get changed for template1?

Wrong question:( Read the above too quickly and did not pick up you
where getting the setting from pg_settings.

Try again.
Is there more than one database cluster on the machine and if so are you
sure you did the initdb on the same cluster as the select..?

>
>>
>> Thanks!
>>
>> Scot Kreienkamp
>>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com