Обсуждение: data convert

Поиск
Список
Период
Сортировка

data convert

От
Jumping
Дата:
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.)

Re: data convert

От
"Scott Marlowe"
Дата:
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

Re: data convert

От
Jumping
Дата:
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.)

Re: data convert

От
"Scott Marlowe"
Дата:
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.