Re: INSTALLING POSTGRESQL 7.4.2 - Mailing list pgsql-novice

From Tom Lane
Subject Re: INSTALLING POSTGRESQL 7.4.2
Date
Msg-id 3940.1085152825@sss.pgh.pa.us
Whole thread Raw
In response to INSTALLING POSTGRESQL 7.4.2  (Philippe VERSCHOOTEN <ph.verschooten@rmnet.be>)
List pgsql-novice
Philippe VERSCHOOTEN <ph.verschooten@rmnet.be> writes:
> I am have been installing version 7.4.2 of postgesql through different
> channels on my PowerBook G4 (OS X 10.2.8).

> creating template1 database in /usr/local/pgsql/data//base/1... FATAL:
> invalid value for parameter "lc_time": "en_US"

We've seen reports like that before; it seems that OS X has rather flaky
(incomplete) support for locales.  I'd suggest forcing use of C locale,
myself.  "initdb --no-locale" will do it IIRC.

            regards, tom lane

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Set search_path
Next
From: Glenn_Wiens@via-christi.org
Date:
Subject: Problem with encode() function