PosgtresSQL master-slave synchronous replication to multiple slaves

Started by Vlad Mihalceaalmost 12 years ago2 messagesgeneral
Jump to latest
#1Vlad Mihalcea
mihalcea.vlad@gmail.com

PostgresSQL has support for master-slave replication, but the synchronous
streaming replication
<http://www.postgresql.org/docs/current/static/warm-standby.html#SYNCHRONOUS-REPLICATION&gt;
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

#2Michael Paquier
michael@paquier.xyz
In reply to: Vlad Mihalcea (#1)
Re: PosgtresSQL master-slave synchronous replication to multiple slaves

On Sat, May 31, 2014 at 5:30 PM, Vlad Mihalcea <mihalcea.vlad@gmail.com> wrote:

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?

As of now, none. Only a single synchronous slave is possible. There
have been discussions about implementing N-synchronous slaves though.
--
Michael

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general