From: Jumping <quzhengping@gmail.com>
To: pgsql-admin@postgresql.org
Subject: data convert
Date: Mon, 5 Jan 2009 03:07:07 +0000
Message-ID: <c640ff2f0901041907h311c591am79ec600441fbaab4@mail.gmail.com> (raw)
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.)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: quzhengping@gmail.com
Subject: Re: data convert
In-Reply-To: <c640ff2f0901041907h311c591am79ec600441fbaab4@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox