Questions about encoding between two databases

From: Archibald Zimonyi <arsi(at)aranzo(dot)netg(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Questions about encoding between two databases
Date: 2009-08-21 06:45:30
Message-ID: alpine.DEB.1.10.0908210843300.13731@szamitogep.zimonyi.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

I am sitting on version 7.4.x and am going to upgrade to version 8.3.x.
>From all I can read I should have no problem with actual format of the
pgdump file (for actual dumping and restoring purposes) but I am
having problems with encoding (which I was fairly sure I would). I have
searched the web for solutions and one solution given (in one thread where
Tom Lane answered) was to set the correct encoding in the version 8.3.x
database.

However, the default encoding in the version 8.3.x instance is
currently UTF8 and I am happy with that. The encoding for most of the
databases in the version 7.4.x was LATIN1. Is there any way I can ignore
the LATIN1 encoding and force the database to accept the UTF8 encoding of
the new version 8.3.x instance?

I get the below message when I try the psql -f <file> <database> command.

psql:aranzo20090812:30: ERROR: encoding LATIN1 does not match server's
locale en_US.UTF-8
DETAIL: The server's LC_CTYPE setting requires encoding UTF8.

Any help would be appreciated.

Archie

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2009-08-21 07:14:36 Re: "ownership" of sequences, pseudo random unique id
Previous Message Ivan Sergio Borgonovo 2009-08-21 06:25:23 bayesian classification over tsvector