Search Postgresql Archives

Re: initdb with lc-collate=C

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

 



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@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.klaver@xxxxxxxxx

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[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