Re: Problem restoring a dump

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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin