Re: [Postgres-xc-general] Primary Key Conflict

[Michael P. <mic...@gm...>]

On Wed, Oct 8, 2014 at 10:23 PM, Gilberto Nunes <gil...@gm...>
wrote:

> So, in other words, I will have this on the clients ( nodes ) and not on
> the central DB (coordinators).
> Sorry if I do not understand cleary what you explain... I am really new in
> DB world...
>
A Postgres-XC cluster is made of a series of Coordinator and Datanodes. But
instead of explaining it by email, I highly recommend that you read some
related documentation that can easily be found on the net and understand
its infrastructure before even trying to use it. Here is for example one:
https://wiki.postgresql.org/images/4/44/Postgres-XC_Write-Scalable_Cluster.pdf

I don't really know what you are trying to solve, but before exploring XC
you should consider as well more simple solutions like a single PostgreSQL
server coupled with some read-only standbys if you are really new in
working on such systems. Multi-master looks great on the paper, with costs
in either hardware, data availability or performance.
Regards,
-- 
Michael