Add some basic support for binary/WAL replicas.

[slony-i/pgbouncer_follower] / pgbouncer_follower_wal_rw.conf

diff --git a/pgbouncer_follower_wal_rw.conf b/pgbouncer_follower_wal_rw.conf
new file mode 100755 (executable)
index 0000000..9b37420
--- /dev/null
+++ b/pgbouncer_follower_wal_rw.conf
@@ -0,0 +1,55 @@
+#------------------------------------------------------------------------------
+# Replication cluster information
+#------------------------------------------------------------------------------
+replication_method=wal                                                         # Possible values 'slony' or 'wal'
+
+replication_user=repuser                                                        # Username to use when connecting to PostgreSQL server to 
+                                                                                # retrieve slony cluster configuration / streaming rep state
+
+replication_pass=                                                               # Password for above, leave blank to use .pgpass
+
+slony_cluster_name=test_replication                                             # Slony-I replication cluster name
+
+#------------------------------------------------------------------------------
+# Server information
+#------------------------------------------------------------------------------
+server_conninfo=dbname=test host=localhost port=5432                            # Conninfo of servers.  For slony this list is used to pull cluster
+server_conninfo=dbname=test host=localhost port=5433                            # configuration from the first contactable node so all nodes not necessarily
+server_conninfo=dbname=test host=localhost port=5434                           # not necessarily required. For WAL replication all servers required.
+
+#------------------------------------------------------------------------------
+# PgBouncer follower information
+#------------------------------------------------------------------------------
+debug=false
+follower_poll_interval=5000                                                     # Cluster state poll interval (milliseconds)
+
+slony_sets_to_follow=all                                                        # Comma separated list of set id's to follow E.g. "1,2,3,4" or "all"
+
+only_follow_origins=true                                                        # If true pgbouncer will only be reconfigured and reloaded
+                                                                                # when the origin of a set / primary moves. If false any 
+                                                                                # changes to origins, providers or subscribers will initiate 
+                                                                                # a reconfigure and reload.
+
+pool_mode=rw                                                                    # Values are rw/ro. "rw" follows the origin node
+                                                                                # whereas "ro" will follow a subscriber  of the sets
+                                                                                # specified in slony_sets_to_follow
+
+pool_all_databases=true                                                         # If true uses a wildcard in the conninfo for the pooler
+                                                                                # thus hosting all databases on the node. If false
+                                                                                # only the database in the target servers conninfo is hosted.
+
+auth_user=                                                                      # If set auth_user will be appended to conninfo written
+                                                                                # in [databases] section.
+
+status_file=/var/run/pgbouncer_follower.status                                  # File used to store tate of the cluster
+log_file=/var/log/pgbouncer_follower.log                                        # Log for pool_follower script
+pid_file=/var/run/pgbouncer_follower.pid                                        # Pidfile for poll mode 
+pool_conf_template=/etc/pgbouncer/pgbouncer.template                            # Template configuration file
+pool_conf_target=/etc/pgbouncer/pgbouncer.ini                                   # Target configuration file to be modified
+pool_reload_command=/etc/init.d/pgbouncer restart                               # Command used to action configuration changes
+                                                                                # Sepcial values for status_file, log_file, pool_conf_template
+                                                                                # pool_conf_target and pool_reload_command parameters:
+                                                                                #   %mode - Pool Mode
+                                                                                #   %clname - Slony cluster name
+max_ro_lag=0                                                                    # Maximum lag in seconds allowed for subscriber nodes when
+                                                                                # running in ro mode. 0 = don't monitor lag.