From: | Bob McConnell <rmcconne(at)lightlink(dot)com> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Overriding local encoding defaults |
Date: | 2010-10-17 16:48:29 |
Message-ID: | 4CBB28DD.3060009@lightlink.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Tom Lane wrote:
> Bob McConnell <rmcconne(at)lightlink(dot)com> writes:
>> I am trying to create a Pg 8.4 cluster with UTF8 encoding for JDBC
>> access. But initdb insists that because my local console is en_US, it
>> cannot do that. We're talking about setting up a server here. Why should
>> it even care what the local console settings are?
>
> You need a locale setting that's compatible with UTF8, and apparently
> your platform's version of "en_US" isn't. Try specifying locale
> en_US.utf8. (There are various ways of spelling that --- "locale -a"
> should give you a clue which one applies for you.)
OK, this seems to work, so far. While logged in as the postgres user, I
typed in:
export LANG=en_US.UTF-8
Then:
initdb -D /home/pgsql/data -E UTF8
built a cluster with UTF8 encoding. Just for safety, I also created
~/.profile with the same export line. So if I accidentally use pgsql via
SSH, I should be safe.
The 'export' syntax came from the CHANGES_AND_HINTS.TXT file for
Slackware 13.1 under SCIM input methods.
I still don't understand why a server process should care about the
local console. Are there any plans to fix that?
Thank you,
Bob McConnell
N2SPP
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-10-17 20:19:42 | Re: Overriding local encoding defaults |
Previous Message | Tom Lane | 2010-10-17 14:25:14 | Re: Overriding local encoding defaults |