1 #------------------------------------------------------------------------------
2 # Slony cluster information
3 #------------------------------------------------------------------------------
4 slony_user=slony # Username to use when connecting to PostgreSQL server to
5 # retrieve slony cluster configuration
7 slony_pass= # Password for above, leave blank to use .pgpass
9 slony_cluster_name=test_replication # Slony-I replication cluster name
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
16 #------------------------------------------------------------------------------
17 # PgBouncer follower information
18 #------------------------------------------------------------------------------
20 follower_poll_interval=5000 # Cluster state poll interval (milliseconds)
22 slony_sets_to_follow=all # Comma separated list of set id's to follow E.g. "1,2,3,4" or "all"
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.
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
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.
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:
45 # %clname - Slony cluster name