From: Vincent Veyron <vv.lists@wanadoo.fr>
To: Oliver <ofabelo@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Change postgresql encoding
Date: Mon, 9 Feb 2015 15:01:07 +0100
Message-ID: <20150209150107.121ab2797f94cd2b8b510a12@wanadoo.fr> (raw)
In-Reply-To: <CALQkqm8TkhTb2JvVFj2Gzr7i0d=LBAYV-V5AXW5rKtRKiaLsOQ@mail.gmail.com>
References: <CALQkqm9fW4Y9SrnDu+TsMd-5eazqwZYLCCy23z33nCwNXQFzJQ@mail.gmail.com>
<54D7CAC4.2010509@aklaver.com>
<CALQkqm-1WRiybmaF_DZ71-vfLMFW6pi7H7vRHg3a7PyiUgiM3w@mail.gmail.com>
<CALQkqm8TkhTb2JvVFj2Gzr7i0d=LBAYV-V5AXW5rKtRKiaLsOQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
On Mon, 9 Feb 2015 08:11:25 +0000
Oliver <ofabelo@gmail.com> wrote:
> 2015-02-09 7:52 GMT+00:00 Oliver <ofabelo@gmail.com>:
>
> > regional configuration name not valid <<es_ES.latin9>>
> > SQL state: 42809
> >
> > I've tried es_ES.iso8859-15 and same error.
>
> If I set encoding to latin9, lc_collate and lc_ctype to 'C', database is
> created correctly, but I'm not sure if it is ok :-? I want have database
> with iso8859-15 encoding.
> My system has, when I run 'locale', the next:
>
The locale must be installed on your system (I work with Debian, so 'dpkg-reconfigure locales'; don't know for RHEL)
Here are the command I used in a similar situation:
#create a latin9 database on a UTF8 cluster:
createdb litigios -E LATIN9 -T template0 -l es_ES.iso885915@euro
psql -c "ALTER DATABASE litigios set lc_time='es_ES.iso885915@euro'" litigios
#load the data (here a latin9 encoded pg_dump)
export PGCLIENTENCODING=LATIN9;
psql -f /path/to/dump/file litigios
--
Salutations, Vincent Veyron
https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats pour le service juridique
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vv.lists@wanadoo.fr, ofabelo@gmail.com, pgsql-general@postgresql.org
Subject: Re: Change postgresql encoding
In-Reply-To: <20150209150107.121ab2797f94cd2b8b510a12@wanadoo.fr>
* 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