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

regenereate data/ locales

From: Maxi Combina <maxicombina(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: regenereate data/ locales
Date: 2005-08-22 14:10:54
Message-ID: 285af08705082207101029a56e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Bruce MomjianDate: 2005-08-22 14:24:37
Subject: Re: sleep?
Previous:From: Michael FuhrDate: 2005-08-22 14:01:33
Subject: Re: sleep?

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