Carlos Henrique Reimer wrote:
> I read some documents about replication and realized
> that if you plan on using asynchronous replication, your
> application should be designed from the outset with that
> in mind because asynchronous replication is not something
> that can be easily “added on” after the fact.
> Am I right?
certainly, if your goal is a pgreplicator style multi-master async, this
is correct, as you have to make decisions about the direction of
data flow, id generation, and conflict resolution up front.
if you want slony-I style single master/multi slave, you don't have to
do so much advance thinking as records are only being inserted into
the system on the single master.
richard