Postgres Pro
Downloads
Home   >   mailing lists

Re: Migration problems with encoding. - Mailing list pgsql-admin

From Shoaib Mir
Subject Re: Migration problems with encoding.
Date
Msg-id bf54be870612120157g6517c67dm63e14646873a1173@mail.gmail.com
Whole thread Raw
In response to Migration problems with encoding.  (Manuel Trujillo <mtrujillo@vlex.com>)
List pgsql-admin
Tree view
Have you tried using 'iconv' for cleaning up the invalid UTF8 character? In case of big files you can always split them.

-----------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com )

On 12/12/06, Manuel Trujillo <mtrujillo@vlex.com> wrote:
Hi!

Firs, I will apologize about my bad english... sorry...

I have a database in postgres 8.0 with encoding defined with UTF8. All
work fine, but because the new features from 8.2 version, we would like
to migrate the database to this new version.
The problem: Encoding incompatibilities between the postgresql version.

How can i resolve this with a database about 16 Gb? Are there any
document about how to solve this?

Thank you very much.

--
Manuel Trujillo Albarral
Responsable de Sistemas
VLEX NETWORKS S.L.
Telf: 93-272.26.85  ext. 111
Jabber/GoogleTalk manu.trujillo@gmail.com
http://www.vlex.com

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

pgsql-admin by date:

Previous
From: Manuel Trujillo
Date:
Subject: Migration problems with encoding.
Next
From: Gábriel Ákos
Date:
Subject: 8.2.0 bug :)