From: Scott Whitney <scott@journyx.com>
To: Marc Fromm <Marc.Fromm@wwu.edu>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: convert from latin1 to utf8
Date: Thu, 10 Oct 2013 18:07:56 -0500 (CDT)
Message-ID: <tjk5oohe6o1g54d3we587607.1381446468103@email.android.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
I needed both UTF8 and Latin-1. I accomplished this by initdb with the LOCALE set to C. That lets me create dbs "with template0 encoding='Latin-1'" as well as "encoding=UTF8," FWIW...
-------- Original message --------
From: Marc Fromm <Marc.Fromm@wwu.edu>
Date: 10/10/2013 5:39 PM (GMT-06:00)
To: pgsql-admin@postgresql.org
Subject: [ADMIN] convert from latin1 to utf8
I need to convert a bunch of my databases to utf8 before I can migrate them to postgresql 8.4. Is there a command that during the pg_dumpall process the encoding can be changed from latin1 to utf8?
This is the error I get when migrating the databases from 8.1 to a machine running 8.4
psql:pgdbs:215: ERROR: encoding LATIN1 does not match locale en_US.UTF-8
DETAIL: The chosen LC_CTYPE setting requires encoding UTF8.
Thanks
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: scott@journyx.com, Marc.Fromm@wwu.edu
Subject: Re: convert from latin1 to utf8
In-Reply-To: <tjk5oohe6o1g54d3we587607.1381446468103@email.android.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