From: | Manasi Save <manasi(dot)save(at)artificialmachines(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Using Postgresql Replication |
Date: | 2010-02-19 10:49:12 |
Message-ID: | 20100219054912.h2y7ff6n8up0kwgw@mail.artificialmachines.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GÜNDÜZ | 2010-02-19 12:12:24 | Re: Using Postgresql Replication |
Previous Message | Brad Littlejohn | 2010-02-18 23:18:26 | Re: Apply WAL logs after database restore |