1 #------------------------------------------------------------------------------
2 # Replication cluster information
3 #------------------------------------------------------------------------------
4 replication_method=wal # Possible values 'slony' or 'wal'
6 replication_user=repuser # Username to use when connecting to PostgreSQL server to
7 # retrieve slony cluster configuration / streaming rep state
9 replication_pass= # Password for above, leave blank to use .pgpass
11 slony_cluster_name=test_replication # Slony-I replication cluster name
13 #------------------------------------------------------------------------------
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.
20 #------------------------------------------------------------------------------
21 # PgBouncer follower information
22 #------------------------------------------------------------------------------
24 follower_poll_interval=5000 # Cluster state poll interval (milliseconds)
26 slony_sets_to_follow=all # Comma separated list of set id's to follow E.g. "1,2,3,4" or "all"
28 only_follow_origins=true # If true pgbouncer will only be reconfigured and reloaded
29 # when the origin of a set / primary moves. If false any
30 # changes to origins, providers or subscribers will initiate
31 # a reconfigure and reload.
33 pool_mode=rw # Values are rw/ro. "rw" follows the origin node
34 # whereas "ro" will follow a subscriber of the sets
35 # specified in slony_sets_to_follow
37 pool_all_databases=true # If true uses a wildcard in the conninfo for the pooler
38 # thus hosting all databases on the node. If false
39 # only the database in the target servers conninfo is hosted.
41 auth_user= # If set auth_user will be appended to conninfo written
42 # in [databases] section.
44 status_file=/var/run/pgbouncer_follower.status # File used to store tate of the cluster
45 log_file=/var/log/pgbouncer_follower.log # Log for pool_follower script
46 pid_file=/var/run/pgbouncer_follower.pid # Pidfile for poll mode
47 pool_conf_template=/etc/pgbouncer/pgbouncer.template # Template configuration file
48 pool_conf_target=/etc/pgbouncer/pgbouncer.ini # Target configuration file to be modified
49 pool_reload_command=/etc/init.d/pgbouncer restart # Command used to action configuration changes
50 # Sepcial values for status_file, log_file, pool_conf_template
51 # pool_conf_target and pool_reload_command parameters:
53 # %clname - Slony cluster name
54 max_ro_lag=0 # Maximum lag in seconds allowed for subscriber nodes when
55 # running in ro mode. 0 = don't monitor lag.