Обсуждение: data convert
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.)
What's cybercluster? On Sun, Jan 4, 2009 at 8:07 PM, Jumping <quzhengping@gmail.com> 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
In many cases asynchronous replication is just not enough to model a certain business case. Therefore Cybertec Schönig & Schönig GmbH offers a synchronous multimaster replication solution for PostgreSQL called Cybercluster. http://www.postgresql.at/english/pr_cybercluster_e.html I want to use it's feature of master-master. On Mon, Jan 5, 2009 at 4:17 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote: > What's cybercluster? > > On Sun, Jan 4, 2009 at 8:07 PM, Jumping <quzhengping@gmail.com> 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 > -- 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.)
Sorry, I was being subtle. I looked it up and it looks interesting. However, I'm betting there's a mailing list for this software that's likely to have more people to answer your question than the -admin list. I'll have to look it up. On Sun, Jan 4, 2009 at 9:48 PM, Jumping <quzhengping@gmail.com> wrote: > In many cases asynchronous replication is just not enough to model a > certain business case. Therefore Cybertec Schönig & Schönig GmbH > offers a synchronous multimaster replication solution for PostgreSQL > called Cybercluster.