Synchronous replication

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Remove the notes describing Simon's 9/2010 patch, and put a link to the wiki page where they have been moved.)
(remove doubled title)
 
Line 1: Line 1:
= Synchronous Replication =
 
 
Synchronous replication is available starting in PostgreSQL 9.1 by enabling the [http://developer.postgresql.org/pgdocs/postgres/runtime-config-wal.html#GUC-SYNCHRONOUS-STANDBY-NAMES synchronous_standby_names] parameter.  It includes user-controlled durability specified on the master using the [http://developer.postgresql.org/pgdocs/postgres/runtime-config-wal.html#GUC-SYNCHRONOUS-COMMIT synchronous_commit] parameter.  The design also provides high throughput by allowing concurrent processes to handle the WAL stream.  
 
Synchronous replication is available starting in PostgreSQL 9.1 by enabling the [http://developer.postgresql.org/pgdocs/postgres/runtime-config-wal.html#GUC-SYNCHRONOUS-STANDBY-NAMES synchronous_standby_names] parameter.  It includes user-controlled durability specified on the master using the [http://developer.postgresql.org/pgdocs/postgres/runtime-config-wal.html#GUC-SYNCHRONOUS-COMMIT synchronous_commit] parameter.  The design also provides high throughput by allowing concurrent processes to handle the WAL stream.  
  

Latest revision as of 17:37, 5 January 2013

Synchronous replication is available starting in PostgreSQL 9.1 by enabling the synchronous_standby_names parameter. It includes user-controlled durability specified on the master using the synchronous_commit parameter. The design also provides high throughput by allowing concurrent processes to handle the WAL stream.

[edit] Design Notes

See also Synchronous Replication 9/2010 Proposal, though those notes pertain to a patch different than what has been committed.

Personal tools