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
