Hi,
anorganic anorganic wrote:
>> did you check the manual about 'High Availability and Load
>> Balancing"?
>> http://www.postgresql.org/docs/8.2/static/high-availability.html
>
yes but this was really short i think.
Interesting... where exactly is it to short for you? What else would you
expect?
I need that: s1 and s2 must be multimaster replication asyn. but make
replication in real time. Changes are immediately send to second server.
Slony can probably be used for such a setup, although it's primarily
designed for single master, async replication.
OR: s1 is master s2 slave, s1 change some columns on s2, and s2 is
master s1
slave and s2 change another columns in one time.
I don't quite follow what you mean here. I assume you mean rows, not
columns. Then probably you mean something like what we call data
partitioning, where each server is a master for a certain subset of the
data.
I read about slony but, it looks that's make changes not immediatly but in
packages = not send one transaction but wait and send package. This
could be a problem.
Hm. If that really is a problem, think again about sync vs. async. In
async replication, there is a delay by definition. But again, I'm not
sure what Slony can do to minimize that delay.
I hope slony online system is right for me. And these question
about slony i have more than one i think it could be rigth way. Somebody
who run it could be great person for me :).
Probably ask on the slony mailing list. I'm not exactly a slony expert
either.
Regards
Markus
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
