Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B565463215C for ; Sun, 4 Jan 2009 23:07:15 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 66126-01 for ; Sun, 4 Jan 2009 23:07:12 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.237]) by mail.postgresql.org (Postfix) with ESMTP id 3D50B6318F3 for ; Sun, 4 Jan 2009 23:07:08 -0400 (AST) Received: by rv-out-0506.google.com with SMTP id b25so8424538rvf.43 for ; Sun, 04 Jan 2009 19:07:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type:content-transfer-encoding :content-disposition; bh=griPlGKi7CokmyorhytEisXPLz2UQP8b+YlI1uo4GfI=; b=IxIpBkzmee19p8YEB/h4scoMPVWajItgZpQ3bi2TGf5YX8XeDAq9qCmqG/AFuVUf3Z XyVPeRSPByCvbb1o2iVgn+vnq7d5blRQXOIx2+ONHzLkAI5YT7GYWxaWtlJZXjPWsLsy 5RIRIAwXdjhxCIVlD1HL+d3PeoGWKr8Klwug8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type :content-transfer-encoding:content-disposition; b=RRJrkI34PpClQAlg5HTPNyrvE7ERguS/Isutk88KC3axBHmut03d8tczAoOd+0r3Ss xCBxJwDWIfMWshPuySAmfpVg4xRMOPrTQIExaHyHdjbkrzhkNDo5m4XEkkwN4ZDse3dl rNaEqq4NCovhGmn7igNh0aoG1rJaHPwSAc5yE= Received: by 10.114.72.1 with SMTP id u1mr13501798waa.203.1231124827092; Sun, 04 Jan 2009 19:07:07 -0800 (PST) Received: by 10.114.38.16 with HTTP; Sun, 4 Jan 2009 19:07:07 -0800 (PST) Message-ID: Date: Mon, 5 Jan 2009 03:07:07 +0000 From: Jumping To: pgsql-admin@postgresql.org Subject: data convert MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/9 X-Sequence-Number: 31056 i update my database from 8.1.9 to cyberclusterr-1.2.0: 1:dump out my database from 8.1.9 the size of sql file is about 1.3G the database initdb use " /opt/postgresql-8.1.9/bin/initdb -D /opt/postgresql-8.1.9/data --encoding=latin1 --lc-ctype=C" 2:dump into cyberclusterr-1.2.0 on node1 ( i have two nodes:node1 and node2) the database initdb use "/opt/cyberclusterr-1.2.0/bin/initdb -D /opt/cyberclusterr-1.2.0/data --encoding=UTF-8" the problem is : the node1 and the node2 could not sync on some tables. Any ideas or hints ? Best Regards. Jumping -- Don't tell me how many enemies we have, but where they are! (ADV:Perl -- It's like Java, only it lets you deliver on time and under budget.)