summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYoshiyuki Asaba2007-07-27 06:24:37 +0000
committerYoshiyuki Asaba2007-07-27 06:24:37 +0000
commitc17ec2f2bba3433261b6563ed4f4539f4aee765e (patch)
tree3f3d3825349f52eff7c68cff5ae99e96bb226995
parent4264a0c9558c65e2f9f9ac065fac7131a1b693ac (diff)
Add description for "replicate_select" directive.
-rw-r--r--README16
1 files changed, 11 insertions, 5 deletions
diff --git a/README b/README
index 5ca8298..1241ef2 100644
--- a/README
+++ b/README
@@ -46,15 +46,17 @@ pgpool version 3.3 README
start the two postmaster then restart pgpool.
While pgpool is in the replication mode, SELECT queries are sent to
- the master node only. If the load balancing is enabled, SELECT's
- are sent to randomly chosen node. If you need to replicate a SELECT
- query which has a side effect of updaing some data, append the
- following comment at the beginning of the query.
+ the master node only if "replicate_select" is false. If the load
+ balancing is enabled, SELECT's are sent to randomly chosen node. If
+ you need to replicate a SELECT query which has a side effect of
+ updaing some data, append the following comment at the beginning of
+ the query.
/*REPLICATION*/ SELCT ...
Note that queries that begin with either "SELECT nextval" or
- "SELECT setval" are automatically replicated.
+ "SELECT setval" are automatically replicated. If "replicate_select"
+ is true, SELECTs are replicated.
1.2 Avoiding deadlocks
@@ -390,6 +392,10 @@ pgpool version 3.3 README
Stop replication mode on data mismatch between master and
secondary. Default is false.
+ replicate_select
+
+ Replicate SELECTs. Default is false.
+
reset_query_list
semicolon separated SQL commands to be issued at the end of