Using Postgresql Replication

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

Responses

Browse pgsql-admin by date

  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