convert from latin1 to utf8

From: Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: convert from latin1 to utf8
Date: 2013-10-10 22:36:44
Message-ID: 93361C67E4EE844A80935863A4FF4B6C076EED0C@Exch2010MB-2.univ.dir.wwu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Whitney 2013-10-10 23:07:56 Re: convert from latin1 to utf8
Previous Message Marc Fromm 2013-10-10 21:51:42 Re: move dbs from 8.1 to 8.4