data convert

From: Jumping <quzhengping(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: data convert
Date: 2009-01-05 03:07:07
Message-ID: c640ff2f0901041907h311c591am79ec600441fbaab4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.)

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-01-05 04:17:41 Re: data convert
Previous Message Scott Marlowe 2009-01-02 20:14:20 Re: access data in php