Re: Locale (unsupported) bug. uk_UA.KOI8-U - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: Locale (unsupported) bug. uk_UA.KOI8-U
Date
Msg-id 48EDF2A1.8080801@gmx.net
Whole thread Raw
In response to Locale (unsupported) bug. uk_UA.KOI8-U  (ivocs admin <gh0st@ivocs.com>)
Responses Re: Locale (unsupported) bug. uk_UA.KOI8-U
List pgsql-bugs
ivocs admin wrote:
> initdb -E ISO-8859-1 -D data/

This is probably not a good idea.  You should specify a locale and let
initdb figure out the matching encoding.  Otherwise you might end up
with an incompatible locale/encoding combination.  (initdb would
probably not even allow this to proceed, but you have other problems as
well, see below.)

> The files belonging to this database system will be owned by user
> "postgres".
> This user must also own the server process.
>
> The database cluster will be initialized with locale uk_UA.KOI8-U.
> could not determine encoding for locale "uk_UA.KOI8-U": codeset is "KOI8-U"
> initdb: could not find suitable text search configuration for locale
> uk_UA.KOI8-U

PostgreSQL currently doesn't support the KOI8-U encoding.  You could
consider using UTF-8 instead.  Try running this

initdb --locale=uk_UA.utf8 -D data/

pgsql-bugs by date:

Previous
From: ivocs admin
Date:
Subject: Locale (unsupported) bug. uk_UA.KOI8-U
Next
From: Peter Eisentraut
Date:
Subject: Re: BUG #4462: Adding COUNT to query causes massive slowdown