pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (2+ messages)  latest in thread

Message-ID: <285af08705082207101029a56e@mail.gmail.com>
Permalink:  ../285af08705082207101029a56e@mail.gmail.com/
Also on:    postgresql.org/message-id/285af08705082207101029a56e@mail.gmail.com

 · 

reply

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