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