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@artificialmachines.com]
Enviado el: viernes, 19 de febrero de 2010 11:49
Para: pgsql-admin@postgresql.org
Asunto: [ADMIN] Using Postgresql Replication
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.
--
Regards,
Manasi Save