diff options
| author | Yoshiyuki Asaba | 2007-07-27 06:24:37 +0000 |
|---|---|---|
| committer | Yoshiyuki Asaba | 2007-07-27 06:24:37 +0000 |
| commit | c17ec2f2bba3433261b6563ed4f4539f4aee765e (patch) | |
| tree | 3f3d3825349f52eff7c68cff5ae99e96bb226995 | |
| parent | 4264a0c9558c65e2f9f9ac065fac7131a1b693ac (diff) | |
Add description for "replicate_select" directive.
| -rw-r--r-- | README | 16 |
1 files changed, 11 insertions, 5 deletions
@@ -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 |
