| 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: | Whole Thread | Raw Message | 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 |