pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
data convert
4+ messages / 2 participants
[nested] [flat]

* data convert
@ 2009-01-05 03:07 Jumping <quzhengping@gmail.com>
  2009-01-05 04:17 ` Re: data convert Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Jumping @ 2009-01-05 03:07 UTC (permalink / raw)
  To: 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.)



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: data convert
  2009-01-05 03:07 data convert Jumping <quzhengping@gmail.com>
@ 2009-01-05 04:17 ` Scott Marlowe <scott.marlowe@gmail.com>
  2009-01-05 04:48   ` Re: data convert Jumping <quzhengping@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Scott Marlowe @ 2009-01-05 04:17 UTC (permalink / raw)
  To: Jumping <quzhengping@gmail.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: data convert
  2009-01-05 03:07 data convert Jumping <quzhengping@gmail.com>
  2009-01-05 04:17 ` Re: data convert Scott Marlowe <scott.marlowe@gmail.com>
@ 2009-01-05 04:48   ` Jumping <quzhengping@gmail.com>
  2009-01-05 05:32     ` Re: data convert Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Jumping @ 2009-01-05 04:48 UTC (permalink / raw)
  To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: pgsql-admin

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


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: data convert
  2009-01-05 03:07 data convert Jumping <quzhengping@gmail.com>
  2009-01-05 04:17 ` Re: data convert Scott Marlowe <scott.marlowe@gmail.com>
  2009-01-05 04:48   ` Re: data convert Jumping <quzhengping@gmail.com>
@ 2009-01-05 05:32     ` Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Scott Marlowe @ 2009-01-05 05:32 UTC (permalink / raw)
  To: Jumping <quzhengping@gmail.com>; +Cc: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2009-01-05 05:32 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-01-05 03:07 data convert Jumping <quzhengping@gmail.com>
2009-01-05 04:17 ` Scott Marlowe <scott.marlowe@gmail.com>
2009-01-05 04:48   ` Jumping <quzhengping@gmail.com>
2009-01-05 05:32     ` Scott Marlowe <scott.marlowe@gmail.com>

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