problem converting database to UTF-8

From: David Goodenough <david(dot)goodenough(at)btconnect(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: problem converting database to UTF-8
Date: 2009-01-22 17:18:16
Message-ID: 200901221718.18590.david.goodenough@btconnect.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a database which was created as LATIN1 (the machine has the
wrong locales installed when I set up PG). It is running 8.3.

So I found various places which said the way to do this was to do
a pg_dumpall -f dump_file, get rid of the entire database, init_db -E UTF-8,
and then psql -f dumpfile.

But the psql fails saying:-

psql:dumpfile:49: ERROR: encoding LATIN1 does not match server's locale
en_GB.UTF-8
DETAIL: The server's LC_CTYPE setting requires encoding UTF8.

I have en_GB.UTF-8 now as my primary locale, and en_GB.ISO8859-1 is
also generated.

So I looked around again and found people saying I needed to use iconv,
but that does not help, I get the same error.

Is there a definative HOWTO that I can follow, if not does someone
have a set of instructions that will work?

If it matters I am running under Debian.

David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2009-01-22 17:20:45 Re: difference between current_timestamp and now() in quotes
Previous Message Jason Long 2009-01-22 17:07:37 Re: difference between current_timestamp and now() in quotes