git.8kb.co.uk Git - slony-i/pgbouncer_follower/blob - pgbouncer_follower_ro.conf

   1 #------------------------------------------------------------------------------
   2 # Replication cluster information
   3 #------------------------------------------------------------------------------
   4 replication_method=slony                                                        # Possible values 'slony' or 'wal'
   5
   6 replication_user=repuser                                                        # Username to use when connecting to PostgreSQL server to
   7                                                                                 # retrieve slony cluster configuration / streaming rep state
   8
   9 replication_pass=                                                               # Password for above, leave blank to use .pgpass
  10
  11 slony_cluster_name=test_replication                                             # Slony-I replication cluster name
  12
  13 #------------------------------------------------------------------------------
  14 # Server information
  15 #------------------------------------------------------------------------------
  16 server_conninfo=dbname=TEST host=localhost port=5432                            # Conninfo of servers.  For slony this list is used to pull cluster
  17 server_conninfo=dbname=TEST host=localhost port=5433                            # configuration from the first contactable node so all nodes not necessarily
  18 server_conninfo=dbname=TEST host=localhost port=5434                            # not necessarily required. For WAL replication all servers required.
  19 server_conninfo=dbname=TEST host=localhost port=5435
  20
  21 #------------------------------------------------------------------------------
  22 # PgBouncer follower information
  23 #------------------------------------------------------------------------------
  24 debug=false
  25 follower_poll_interval=5000                                                     # Cluster state poll interval (milliseconds)
  26
  27 slony_sets_to_follow=all                                                        # Comma separated list of set id's to follow E.g. "1,2,3,4" or "all"
  28
  29 only_follow_origins=false                                                       # If true pgbouncer will only be reconfigured and reloaded
  30                                                                                 # when the origin of a set / primary moves. If false any
  31                                                                                 # changes to origins, providers or subscribers will initiate
  32                                                                                 # a reconfigure and reload.
  33
  34 pool_mode=ro                                                                    # Values are rw/ro. "rw" follows the origin node
  35                                                                                 # whereas "ro" will follow a subscriber  of the sets
  36                                                                                 # specified in slony_sets_to_follow
  37
  38 pool_all_databases=false                                                        # If true uses a wildcard in the conninfo for the pooler
  39                                                                                 # thus hosting all databases on the node. If false
  40                                                                                 # only the database in the target servers conninfo is hosted.
  41
  42 auth_user=                                                                      # If set auth_user will be appended to conninfo written
  43                                                                                 # in [databases] section.
  44
  45 status_file=/var/run/pgbouncer_follower_%mode.status                            # File used to store tate of the cluster
  46 log_file=/var/log/pgbouncer_follower_%mode.log                                  # Log for pool_follower script
  47 pid_file=/var/run/pgbouncer_follower_%mode.pid                                  # Pidfile for poll mode
  48 pool_conf_template=/etc/pgbouncer/pgbouncer_%mode.template                      # Template configuration file
  49 pool_conf_target=/etc/pgbouncer/pgbouncer_%mode.ini                             # Target configuration file to be modified
  50 pool_reload_command=/etc/init.d/pgbouncer_%mode restart                         # Command used to action configuration changes
  51                                                                                 # Sepcial values for status_file, log_file, pool_conf_template
  52                                                                                 # pool_conf_target and pool_reload_command parameters:
  53                                                                                 #   %mode - Pool Mode
  54                                                                                 #   %clname - Slony cluster name
  55 max_ro_lag=1200                                                                 # Maximum lag in seconds allowed for subscriber nodes when
  56                                                                                 # running in ro mode. 0 = don't monitor lag.