|
PGcluster doesn’t work. One year ago we where trying to deploy a
cluster using pgcluster and we were unable to get it work without problems. We finally selected slony. It works quite well and it’s quite
easy to deploy by following tutorials. We worked with slony-I. However, slony
only replicate data. You have to replicate manually triggers, functions,
indexes, etc if you use them. We also tested pg pool and this one works very good. However you
have to deal with some minor issues if you use special functions that make use of
timestamps or random, for example. If you don’t use this kind of functions, you
could test pg_pool. Pg_pool is easier to deploy than slony and also provides load
balancing for reading. De: Manasi Save
[mailto:manasi.save@xxxxxxxxxxxxxxxxxxxxxx] Hi All, I am very new to Postgres in that I have to setup replication. For Which I
am very confused between Postgres's replication types. I want a sychronized but a master-slave replication. I have read about Slony-I replication method. But I am confused if I have to
manually setup slony-I replication for all databases. As the interface which I
have seen for slony-I setup, it has given replication tab under every database.
If I have to manually define replication master and slave node for any
database I am creating then it is not a feasible option for me to use
Slony-I. SLONY-I = Is it possible that all the databases getting created on Master Node
will be replicated to specified Slave node. So, I thought of PGCluster. But it comes with multi-master replication. PGCluster = Is it possible that I can configure Master-Slave replication in
PGCluster. Please let me know if I am unclear in any point. Any input will be a great
help. Thanks in advance.
|
