Re: Setting locale

Does it mean that I have to initdb postgresql with the locale settings?

On Mon, Jun 21, 2010 at 10:54 PM, Thom Brown <thombrown(at)gmail(dot)com> wrote:

> On 21 June 2010 21:51, Thom Brown <thombrown(at)gmail(dot)com> wrote:
> > On 21 June 2010 21:28, Laslo Forro <getforum(at)gmail(dot)com> wrote:
> >> Hi there,
> >> I am trying to set the --locale for a database but receive 'invalid
> locale
> >> name'
> >> Here is the posgresql.conf part:
> >> lc_messages = 'en_US.UTF-8' # locale for system error message
> >> # strings
> >> lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
> >> lc_numeric = 'en_US.UTF-8' # locale for number formatting
> >> lc_time = 'en_US.UTF-8' # locale for time formatting
> >> default_text_search_config = 'pg_catalog.english'
> >> locale -a says:
> >> C
> >> en_US.utf8
> >> hu_HU.utf8
> >> POSIX
> >> I would like to use hu_HU.utf8:
> >> createdb -E UTF8 --locale='hu_HU.utf8' test
> >> Password:
> >> createdb: database creation failed: ERROR: invalid locale name
> hu_HU.utf8
> >> Postgresql is on Debian. Default locale is en_US.utf8
> >> Any idea is appreciated.
> >
> > What do you get with: locale -a | grep hr_HR
> >
> > Thom
> >
>
> Erk... no, my mistake. Ignore my last message.
>
> In any case, shouldn't it be: createdb -E utf8 --locale='hu_HU' test
>
> Thom
>