From c74d3aceb99ea6c6d102109349b514e76e497592 Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Mon, 7 Mar 2011 11:59:58 -0500 Subject: [PATCH] Synchronous replication doc corrections. Thom Brown --- doc/src/sgml/config.sgml | 2 +- doc/src/sgml/high-availability.sgml | 9 +++------ 2 files changed, 4 insertions(+), 7 deletions(-) diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 822ef4b60c..ec7e44315f 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -2092,7 +2092,7 @@ SET ENABLE_SEQSCAN TO OFF; If a standby is removed from the list of servers then it will stop - being the synchronous standby, allowing another to take it's place. + being the synchronous standby, allowing another to take its place. If the list is empty, synchronous replication will not be possible, whatever the setting of synchronous_replication, however, already waiting commits will continue to wait. diff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgml index e30552f09f..e33d315137 100644 --- a/doc/src/sgml/high-availability.sgml +++ b/doc/src/sgml/high-availability.sgml @@ -927,7 +927,7 @@ primary_conninfo = 'host=192.168.1.50 port=5432 user=foo password=foopass' All parameters have useful default values, so we can enable - synchronous replication easily just by setting this on the primary + synchronous replication easily just by setting this on the primary: synchronous_replication = on @@ -938,7 +938,7 @@ synchronous_replication = on even if that takes a very long time. synchronous_replication can be set by individual users, so can be configured in the configuration file, for particular - users or databases, or dynamically by applications programs. + users or databases, or dynamically by applications. @@ -1008,9 +1008,6 @@ synchronous_replication = on You should consider that the network bandwidth must be higher than the rate of generation of WAL data. - 10% of changes are important customer details, while - 90% of changes are less important data that the business can more - easily survive if it is lost, such as chat messages between users. @@ -1019,7 +1016,7 @@ synchronous_replication = on Planning for High Availability - Commits made when synchronous_replication is set will wait until at + Commits made when synchronous_replication is set will wait until the sync standby responds. The response may never occur if the last, or only, standby should crash. -- 2.40.0