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

   1 #------------------------------------------------------------------------------
   2 # Slony cluster information
   3 #------------------------------------------------------------------------------
   4 slony_user=slony                                                                # Username to use when connecting to PostgreSQL server to
   5                                                                                 # retrieve slony cluster configuration
   6
   7 slony_pass=                                                                     # Password for above, leave blank to use .pgpass
   8
   9 slony_cluster_name=test_replication                                             # Slony-I replication cluster name
  10
  11 server_conninfo=dbname=TEST host=localhost port=5432                            # Conninfo of server to to retrieve slony cluster configuration
  12 server_conninfo=dbname=TEST host=localhost port=5433                            # from, accepts multiple servers and will try in order given.
  13 server_conninfo=dbname=TEST host=localhost port=5434
  14 server_conninfo=dbname=TEST host=localhost port=5435
  15
  16 #------------------------------------------------------------------------------
  17 # PgBouncer follower information
  18 #------------------------------------------------------------------------------
  19 debug = false
  20 follower_poll_interval=5000                                                     # Cluster state poll interval (milliseconds)
  21
  22 slony_sets_to_follow=all                                                        # Comma separated list of set id's to follow E.g. "1,2,3,4" or "all"
  23
  24 only_follow_origins=true                                                        # If true pgbouncer will only be reconfigured and reloaded
  25                                                                                 # when the origin of a set moves. If false any changes to origins,
  26                                                                                 # providers or subscribers will initiate a reconfigure and reload.
  27
  28 pool_mode=rw                                                                    # Values are rw/ro. "rw" follows the origin node
  29                                                                                 # whereas "ro" will follow a subscriber  of the sets
  30                                                                                 # specified in slony_sets_to_follow
  31
  32 pool_all_databases=false                                                        # If true uses a wildcard in the conninfo for the pooler
  33                                                                                 # thus hosting all databases on the node. If false
  34                                                                                 # only the replicated database is hosted.
  35
  36 status_file=/var/slony/pgbouncer_follower/pgbouncer_follower_%mode.status       # File used to store tate of the cluster
  37 log_file=/var/slony/pgbouncer_follower/pgbouncer_follower_%mode.log             # Log for pool_follower script
  38 pid_file=/var/run/pgbouncer_follower_%mode.pid                                  # Pidfile for poll mode
  39 pool_conf_template=/etc/pgbouncer/pgbouncer_%mode.template                      # Template configuration file
  40 pool_conf_target=/etc/pgbouncer/pgbouncer_%mode.ini                             # Target configuration file to be modified
  41 pool_reload_command=/etc/init.d/pgbouncer_%mode reload                          # Command used to action configuration changes
  42                                                                                 # Sepcial values for status_file, log_file, pool_conf_template
  43                                                                                 # pool_conf_target and pool_reload_command parameters:
  44                                                                                 #   %mode - Pool Mode
  45                                                                                 #   %clname - Slony cluster name