Puppet Class: pgpool::config::failover

Defined in:
manifests/config/failover.pp

Overview

Class: pgpool::config::failover

This class allows for the configuration of the failover and recovery options in the pgpool.conf file.

Parameters

failover_command

String. The command to run when a node is detached. Defaults to .

failback_command

String. The command to run when a node is attached. Defaults to .

fail_over_on_backend_error

String. If true and an error occurs when communicating witht he backend, pgpool will trigger the failover procedure. Defaults to on.

search_primary_node_timeout

Integer. The max amoutn of time in seconds to search for a primary node when in a failover scenario. Defaults to 10.

recovery_user

String. The postgresql username for online recovery. Defaults to nobody.

recovery_password

String. The password for the user for online recovery. Defaults to .

recovery_1st_stage_command

String. The command to be run on the master servier at the first stage of online recovery. Defaults to .

recovery_2nd_stage_command

String. The command to be run on the master at the second stage of online recovery. Defaults to .

recovery_timeout

Integer. During recovery, pgpool won’t accept connections so this is a timeout value to wait during recovery before it gives up and accepts connections. Defaults to 90.

client_idle_limit_in_recovery

Integer. Time to disconnect idle connections during online recovery. Defaults to 0.

Variables

N/A

Examples

N/A

Authors

Alex Schultz <aschultz@next-development.com>

Parameters:

  • failover_command (Any) (defaults to: '')
  • failback_command (Any) (defaults to: '')
  • fail_over_on_backend_error (Any) (defaults to: 'on')
  • search_primary_node_timeout (Any) (defaults to: 10)
  • recovery_user (Any) (defaults to: 'nobody')
  • recovery_password (Any) (defaults to: '')
  • recovery_1st_stage_command (Any) (defaults to: '')
  • recovery_2nd_stage_command (Any) (defaults to: '')
  • recovery_timeout (Any) (defaults to: 90)
  • client_idle_limit_in_recovery (Any) (defaults to: 0) 


66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
 
# File 'manifests/config/failover.pp', line 66

class pgpool::config::failover (
  $failover_command              = '',
  $failback_command              = '',
  $fail_over_on_backend_error    = 'on',
  $search_primary_node_timeout   = 10,
  $recovery_user                 = 'nobody',
  $recovery_password             = '',
  $recovery_1st_stage_command    = '',
  $recovery_2nd_stage_command    = '',
  $recovery_timeout              = 90,
  $client_idle_limit_in_recovery = 0,
) {

  $failover_config = {
    'failover_command'              => { value => $failover_command },
    'failback_command'              => { value => $failback_command },
    'fail_over_on_backend_error'    => { value => $fail_over_on_backend_error },
    'search_primary_node_timeout'   => { value => $search_primary_node_timeout },
    'recovery_user'                 => { value => $recovery_user },
    'recovery_password'             => { value => $recovery_password },
    'recovery_1st_stage_command'    => { value => $recovery_1st_stage_command },
    'recovery_2nd_stage_command'    => { value => $recovery_2nd_stage_command },
    'recovery_timeout'              => { value => $recovery_timeout },
    'client_idle_limit_in_recovery' => { value => $client_idle_limit_in_recovery },
  }

  $failover_defaults = {
    ensure => present
  }

  create_resources(pgpool::config::val, $failover_config, $failover_defaults)
}