From c17ec2f2bba3433261b6563ed4f4539f4aee765e Mon Sep 17 00:00:00 2001 From: Yoshiyuki Asaba Date: Fri, 27 Jul 2007 06:24:37 +0000 Subject: [PATCH] Add description for "replicate_select" directive. --- README | 16 +++++++++++----- 1 file 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 -- 2.39.5