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

   1 #------------------------------------------------------------------------------
   2 # General behaviour
   3 #------------------------------------------------------------------------------
   4 lang = en                                   # Language for script strings
   5                                             # currently only en/fr
   6
   7 prefix_directory = /usr/failovers           # Script working directory
   8 separate_working_directory = true           # Creates and appends a separate working
   9                                             # directory to the prefix_directory
  10                                             # for each script run
  11
  12 pid_filename = /var/run/slony_failover.pid  # If the pid file name starts with a
  13                                             # forward slash then taken as absoloute
  14                                             # othewise appended to prefix_directory
  15
  16 slonik_path = /usr/local/pgsql/bin          # Slonik binary if not in current path
  17
  18 enable_try_blocks = false                   # Group operations inside try blocks when
  19                                             # doing a move set; only works with 'single'
  20                                             # lockset_method
  21
  22 lockset_method = multiple                   # Used for MOVE SET
  23                                             # multiple = lock all sets and move together
  24                                             # single = lock and move each set at a time
  25
  26 pull_aliases_from_comments = false          # Try to generate aliases in the
  27                                             # slonik scripts based on comments within
  28                                             # sl_node/set comments in parentheses
  29
  30 log_line_prefix = [%t PID=%p]               # Special values:
  31                                             #   %p = process ID
  32                                             #   %t = timestamp without milliseconds
  33                                             #   %m = timestamp with milliseconds
  34
  35 failover_offline_subscriber_only = true     # If set to true any subscriber only nodes
  36                                             # that are unavailable at the time of failover
  37                                             # will also be failed over.  If false any such
  38                                             # nodes will be excluded from the preamble and
  39                                             # not failed over, however this may be problematic
  40                                             # especially in the case where the most up to date
  41                                             # node is the unavailable one.
  42
  43 drop_failed_nodes = true                    # Drop all failed nodes immediately
  44
  45 #------------------------------------------------------------------------------
  46 # Database node to read initial Slony-I configuration from
  47 #------------------------------------------------------------------------------
  48 slony_database_host = localhost
  49 slony_database_port = 5434
  50 slony_database_name = TEST
  51 slony_database_user = slony
  52 slony_database_password =                   # Recommended to leave blank and use .pgpass
  53 slony_cluster_name = test_replication
  54
  55
  56 #------------------------------------------------------------------------------
  57 # Logging and debugging
  58 #------------------------------------------------------------------------------
  59 enable_debugging = false
  60 log_filename = failover-%Y-%m-%d.log        # If the log file name starts with a
  61                                             # forward slash then taken as absoloute
  62                                             # othewise appended to prefix_directory
  63                                             # Special values as per strftime spec
  64
  65
  66 log_to_postgresql = false                   # Save log n a PostgreSQL table (table def in failover_log_database.sql)
  67 log_database_host = localhost
  68 log_database_port = 5432
  69 log_database_name = TEST_FAILOVERS
  70 log_database_user = failover_log_user
  71 log_database_password =                     # Recommended to leave blank and use .pgpass
  72
  73 #------------------------------------------------------------------------------
  74 # Autofailover
  75 #------------------------------------------------------------------------------
  76 enable_autofailover = false                 # Rather than interactive mode sit and
  77                                             # watch the cluster state for failed
  78                                             # origin/forwarding nodes; upon detection
  79                                             # trigger automated failover.
  80
  81 autofailover_forwarding_providers = true    # Also trigger failover on forwarding providers
  82
  83 autofailover_config_any_node = true         # After reading the initial cluster configuration,
  84                                             # subsequent reads of the configuration will
  85                                             # use conninfo to read from any node.
  86
  87 autofailover_poll_interval = 50             # Cluster state poll interval (milliseconds)
  88 autofailover_node_retry = 2                 # Retries before initiating failover
  89 autofailover_sleep_time = 5000              # Interval between retries (milliseconds)