From: | Johannes Truschnigg <johannes(at)truschnigg(dot)info> |
---|---|
To: | arvind chikne <arvind(dot)chikne(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Master slave replication |
Date: | 2018-05-14 18:41:24 |
Message-ID: | 20180514184124.ehlebmoaxisltw4s@vault.lan |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Mon, May 14, 2018 at 11:29:22PM +0530, arvind chikne wrote:
> HI All,
>
> From the past few years I am working on standalone postgres database, but
> now want to setup the master slave (Active-passive) and master master
> (Active-Active) replication of the postgres database, can any one suggest
> me how can I archive the same, any good document is much appreciate.
For creating a streaming replication slave from scratch, check out the
`pg_basebackup` tool. Exercised right, it will even create a suitable
recovery.conf for running a slave instance from the backup it creates. You
should also check out Zalando's patroni[0], which is a popular solution for
providing automatic failover capabilities for postgres master/slave-pairs.
Postgres doesn't support multi-master replication; if you're interested in
exploring this anyway, take a look at the BDR project[1].
[0]: https://github.com/zalando/patroni
[1]: https://www.2ndquadrant.com/en/resources/postgres-bdr-2ndquadrant/
--
with best regards:
- Johannes Truschnigg ( johannes(at)truschnigg(dot)info )
www: https://johannes.truschnigg.info/
phone: +43 650 2 133337
xmpp: johannes(at)truschnigg(dot)info
Please do not bother me with HTML-email or attachments. Thank you.
From | Date | Subject | |
---|---|---|---|
Next Message | arvind chikne | 2018-05-14 18:51:05 | Re: Master slave replication |
Previous Message | Johannes Truschnigg | 2018-05-14 18:31:54 | Re: Streaming Replication Networking Best Practices? |