PosgtresSQL master-slave synchronous replication to multiple slaves

From: Vlad Mihalcea <mihalcea(dot)vlad(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PosgtresSQL master-slave synchronous replication to multiple slaves
Date: 2014-05-31 08:30:08
Message-ID: CA+gWKMBBB3eyCxLHT_0OPawVh4VseeJDTZFeepALDjpOPQ9cPw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

PostgresSQL has support for master-slave replication, but the synchronous
streaming replication
<http://www.postgresql.org/docs/current/static/warm-standby.html#SYNCHRONOUS-REPLICATION>
only supports a single synchronous slaves. You can have multiple slaves,
but only one will be synchronously updated the others being eventually
consistent.

Synchronous replication offers the ability to confirm that all changes made
by a transaction have been transferred to one synchronous standby server.
This extends the standard level of durability offered by a transaction
commit. This level of protection is referred to as 2-safe replication in
computer science theory.

If you run a large enterprise system in a master-slave replication scheme
on top of PostgreSQL, what options do I have for enabling multiple
synchronous slaves? Has anyone been able to set-up such replication
configuration?
Original SQL question:

http://stackoverflow.com/questions/23954844/posgtressql-master-slave-synchronous-replication-to-multiple-slaves

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Satish K Biradar 2014-05-31 10:04:21 Re: Archive# views
Previous Message reiner peterke 2014-05-31 08:01:29 Re: unable to build postgres-9.4 in os x 10.9 with python