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
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 |