From: Maxi Combina <maxicombina@gmail.com>
To: pgsql-admin@postgresql.org
Subject: regenereate data/ locales
Date: Mon, 22 Aug 2005 11:10:54 -0300
Message-ID: <285af08705082207101029a56e@mail.gmail.com> (raw)
Hello,
I am using postgresql 7.4.5, and was having some trouble with the
initcap() function. The problem was the following:
initcap('aéeou') = AéEou,
and I need
initcap('aéeou') = Aéeou,
I found in the documentation that to correct this behaviour, I must
run initdb --locale=SOMETHING.
Well, I did it (with --locale=es_AR), and now it works!
However, I could not did it in an easy way, because initdb complained
saying that the data/ directory was not empty. So, I had to dump all
my databases, remove the files from data/, run `initdb --locale=es_AR'
and restore the databases.
Is there any shorter way to change the locales? I didnot found any
`recreate' or `regenerate' command.
Regards,
Maxi
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: maxicombina@gmail.com
Subject: Re: regenereate data/ locales
In-Reply-To: <285af08705082207101029a56e@mail.gmail.com>
References: <285af08705082207101029a56e@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox