Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id C7232B5DC1F
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 13 Sep 2011 06:58:41 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 00214-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 13 Sep 2011 09:58:35 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from delta01.pnet.xcon.it (delta01.pnet.xcon.it [62.48.53.16])
	by mail.postgresql.org (Postfix) with ESMTP id EF92BB5DBD6
	for <pgsql-admin@postgresql.org>; Tue, 13 Sep 2011 06:58:34 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by delta01.pnet.xcon.it (Postfix) with ESMTP id ABA8F1033DC0D;
	Tue, 13 Sep 2011 11:58:34 +0200 (CEST)
X-Virus-Scanned: Debian amavisd-new at delta01.pnet.xcon.it
Received: from delta01.pnet.xcon.it ([127.0.0.1])
	by localhost (delta01.pnet.xcon.it [127.0.0.1]) (amavisd-new,
	port 10024)
	with LMTP id 7uzB2I6A2Y5p; Tue, 13 Sep 2011 11:58:31 +0200 (CEST)
Received: from webmail.xcon.it (delta02.pnet.xcon.it [62.48.53.98])
	(Authenticated sender: gabriele.bartolini@2ndquadrant.it)
	by delta01.pnet.xcon.it (Postfix) with ESMTPSA id 3B5821033F679;
	Tue, 13 Sep 2011 11:58:30 +0200 (CEST)
Received: from eggIB-wan.comune.prato.it ([193.43.108.2]) by webmail.xcon.it
	with HTTP (HTTP/1.1 POST); Tue, 13 Sep 2011 11:58:29 +0200
MIME-Version: 1.0
Content-Type: text/plain;
 charset=UTF-8;
 format=flowed
Content-Transfer-Encoding: 7bit
Date: Tue, 13 Sep 2011 11:58:29 +0200
From: Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
To: giulio calacoci <giulio.calacoci@2ndquadrant.it>
Cc: Johann Spies <jspies@sun.ac.za>, <pgsql-admin@postgresql.org>
Subject: Re: Problem restoring a dump
In-Reply-To: <7728C00C-EFC8-401E-A0A5-76A253269C89@2ndquadrant.it>
References: <20110913091831.GA26669@sun.ac.za>
	<7728C00C-EFC8-401E-A0A5-76A253269C89@2ndquadrant.it>
Message-ID: <196cf71cbca8f7fb8505fb2da9469fbe@2ndquadrant.it>
X-Sender: Gabriele.Bartolini@2ndQuadrant.it
User-Agent: [X]con Webmail/0.4.2
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201109/79
X-Sequence-Number: 38316

 Hi Johann,

    as Giulio pointed out, it seems like the destination database is in 
 LATIN1 encoding, rather than UTF8. Could you please confirm this?

    By reading the little information we have, it seems like you have an 
 export in UTF8 and you are trying to load it into a LATIN1 database. If 
 you specify the client_encoding you are actually informing psql that you 
 are reading UTF8 - which is probably fine given the above assumptions - 
 but that does not specify how the information is then stored in the 
 database. That's decided by the database encoding.

    Also, I suggest that you dump your database using the destination 
 version's pg_dump rather than the source's.

    Please keep us posted.

 Cheers,
 Gabriele

 On Tue, 13 Sep 2011 11:43:27 +0200, giulio calacoci 
 <giulio.calacoci@2ndquadrant.it> wrote:
> hi,
>
> the character that is giving you troubles is "orizontal ellipsis",
> this character does not exists in latin1 encoding, only in utf8, so
> database you dumped was utf8 encoded.
>
> i think the fastest way you have to solve the problem is:  change the
> encoding of the target database you are trying to restore.
>
> Regards
>
> Giulio.
>
> Il giorno 13/set/2011, alle ore 11.18, Johann Spies ha scritto:
>
>> Good day,
>>
>> I have installed postgresql 9.0 on my Debian and thought that 
>> restoring
>> the database would be as simple as psql -f <the dump made by 8.4's
>> pg_dumpall>.
>>
>> However: I get several errors like this:
>>
>> psql:pgdump.txt.1:4453471: ERROR:  character 0xe280a6 of encoding 
>> "UTF8"
>> has no equivalent in "LATIN1"
>>
>> I have changed the client-encoding of psql to UTF8 but I see after 
>> the
>> restore of the dump the encoding is still LATIN1.
>>
>> How do I overcome this?
>>
>> Regards
>> Johann
>> --
>> Johann Spies                            Telefoon: 021-808 4699
>> Databestuurder /  Data manager
>>
>> Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
>> Centre for Research on Evaluation, Science and Technology
>> Universiteit Stellenbosch.
>>
>>     "For my thoughts are not your thoughts, neither are
>>      your ways my ways, saith the LORD. For as the heavens
>>      are higher than the earth, so are my ways higher than
>>      your ways, and my thoughts than your thoughts."
>>                               Isaiah 55:8,9
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin

-- 
  Gabriele Bartolini - 2ndQuadrant Italia
  PostgreSQL Training, Services and Support
  Gabriele.Bartolini@2ndQuadrant.it - www.2ndQuadrant.it