Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0D6F39F9F46 for ; Tue, 12 Dec 2006 05:53:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 67897-10 for ; Tue, 12 Dec 2006 05:53:40 -0400 (AST) X-Greylist: delayed 00:06:40.761694 by SQLgrey-1.7.4 Received: from isengard.vlex.com (isengard.vlex.com [87.236.247.10]) by postgresql.org (Postfix) with ESMTP id B4FC59F9357 for ; Tue, 12 Dec 2006 05:53:39 -0400 (AST) Received: (qmail 24419 invoked by uid 89); 12 Dec 2006 09:50:43 -0000 Received: by simscan 1.2.0 ppid: 24414, pid: 24416, t: 0.2818s scanners: attach: 1.2.0 clamav: 0.88.4/m:40/d:2041 Received: from unknown (HELO ?192.168.10.77?) (mtrujillo@vlex.com@217.126.10.242) by isengard.vlex.com with (DHE-RSA-AES256-SHA encrypted) SMTP; 12 Dec 2006 09:50:43 -0000 Message-ID: <457E7AC9.9010101@vlex.com> Date: Tue, 12 Dec 2006 10:47:53 +0100 From: Manuel Trujillo User-Agent: Thunderbird 1.5.0.8 (X11/20061115) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Migration problems with encoding. X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=BAYES_50, SPF_PASS X-Spam-Level: X-Archive-Number: 200612/153 X-Sequence-Number: 23945 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