Skip site navigation (1) Skip section navigation (2)

Setting locale

From: Laslo Forro <getforum(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Setting locale
Date: 2010-06-21 20:28:08
Message-ID: AANLkTimvHCbPLP7dhGVS3ZkwQ-NxwZw3PBjZChP92IaO@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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.

Responses

pgsql-novice by date

Next:From: Thom BrownDate: 2010-06-21 20:43:29
Subject: Re: Migration Advise
Previous:From: Morris, RoyDate: 2010-06-21 20:12:06
Subject: Migration Advise

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group