Encodings

Lists: pgsql-general
From: "Jan Cruz" <malebug(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Encodings
Date: 2006-02-20 07:55:23
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-general

When restoring a dump from sql_ascii encoding to latin9/utf8
the "THIS STRING|" result to "THIS STRINGÅ " thus it aborted the restore.

When I tried to dump a latin9/utf8 and restore it with the same encoding
having same string it goes well but it took a very long time to copy all
data.
(1.6gb dump for 24/hrs)

So far I don't know what seems to be the problem why it took so long to copy
the dump if it is already in latin9/utf8 encoding to latin9/utf8 database.


From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: "Jan Cruz" <malebug(at)gmail(dot)com>
Subject: Re: Encodings
Date: 2006-02-20 09:02:04
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-general

Am Montag, 20. Februar 2006 08:55 schrieb Jan Cruz:
> When restoring a dump from sql_ascii encoding to latin9/utf8

This statement is both poorly specified and nonsensical. Please give us a
more precise account of what you are doing.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/