Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 0334462DBDB for ; Mon, 5 Jan 2009 01:01:46 -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 87276-05-2 for ; Mon, 5 Jan 2009 01:01:40 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.182]) by mail.postgresql.org (Postfix) with ESMTP id 4E7786322E1 for ; Mon, 5 Jan 2009 00:17:44 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id j4so3973805wah.19 for ; Sun, 04 Jan 2009 20:17:41 -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:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=yL6aeA7h1cHjZx6JKHco/zaGB0VIO/nmxQiMhx0gLKw=; b=ONgZFVLXyvMbkfdq2LhE1APS0b/cqBeS1/yQzkR7AEFV8N1WDWAJeULNUKDvAdPqVp r6lpFgFhp+KPeJwNZ1bOH9uP72qeYCL2w4ZJosRPfq8CJGQ9Hn5EgrobD5G7EIICfONF RzLtqdqiCVpBt9R/pFv2bnGWxpXZSYqBJ4AKo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=jacyUYGZaLOezThFKxQ2R+bgh9MEP8HOpY2pqmOpxqRxAopNdW/L6uHWxRPltIE/Ws BztMrdpzOlcD/zF9Kh8uvpP4HX8VcJCxickIWAeISRHIxWCQCHTse4mgtONmHCeSNVvc xZwMTc41fEEBvES0rqVm23Hzqsd04zsG3ylW0= Received: by 10.114.130.1 with SMTP id c1mr13535877wad.73.1231129061895; Sun, 04 Jan 2009 20:17:41 -0800 (PST) Received: by 10.114.135.4 with HTTP; Sun, 4 Jan 2009 20:17:41 -0800 (PST) Message-ID: Date: Sun, 4 Jan 2009 21:17:41 -0700 From: "Scott Marlowe" To: Jumping Subject: Re: data convert Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: 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/10 X-Sequence-Number: 31057 What's cybercluster? On Sun, Jan 4, 2009 at 8:07 PM, Jumping wrote: > 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.) > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- When fascism comes to America, it will be draped in a flag and carrying a cross - Sinclair Lewis