RPM init-script: Why the locale setting?

From: Troels Arvin <troels(at)arvin(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: RPM init-script: Why the locale setting?
Date: 2004-04-04 20:48:12
Message-ID: pan.2004.04.04.20.48.11.495866@arvin.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

In the init-script contained in the RPMs downloadable from the PostgreSQL
site (I checked the one for Fedora), an explicit locale is set before
running initdb. - And the explicit locale is not "C".

This means that a PostgreSQL installation will not use indexes for LIKE
queries (I just ran into this). See
http://www.postgresql.org/docs/faqs/FAQ.html#4.8

I suggest that the init-script be rewritten so that LANG and LC_ALL are
unset before initdb is run (which happens the first time PostgreSQL is
started after the RPM-based installation).

--
Greetings from Troels Arvin, Copenhagen, Denmark

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Thomas 2004-04-04 22:33:24 Re: RPM init-script: Why the locale setting?
Previous Message wespvp 2004-04-04 20:20:30 Re: thread_test.c problems