1 #------------------------------------------------------------------------------
2 # Replication cluster information
3 #------------------------------------------------------------------------------
4 replication_method=slony # 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.
19 server_conninfo=dbname=TEST host=localhost port=5435
21 #------------------------------------------------------------------------------
22 # PgBouncer follower information
23 #------------------------------------------------------------------------------
25 follower_poll_interval=5000 # Cluster state poll interval (milliseconds)
27 slony_sets_to_follow=all # Comma separated list of set id's to follow E.g. "1,2,3,4" or "all"
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.
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
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.
42 auth_user= # If set auth_user will be appended to conninfo written
43 # in [databases] section.
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:
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.