Re: Using Postgresql Replication

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(dot)save(at)artificialmachines(dot)com]
Enviado el: viernes, 19 de febrero de 2010 11:49
Para: pgsql-admin(at)postgresql(dot)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