002-repmgr.yml

---
# Required configuration items
repmgr_target_group: ""
repmgr_user: repmgr
repmgr_password: repmgr
repmgr_database: repmgr
repmgr_conninfo: "host={{ ansible_hostname }} user={{ repmgr_user }} dbname={{ repmgr_database }} connect_timeout=2"
repmgr_data_directory: "{{ postgresql_data_directory }}"
# Loads the matching configuration file located in role's templates folder 
repmgr_version: 5.3

# Optional configuration items
#

# Repositories
repmgr_apt_repository_add: true
repmgr_gpg_key_url: https://dl.2ndquadrant.com/gpg-key.asc
repmgr_apt_repository: "deb [arch=amd64] https://dl.2ndquadrant.com/default/release/apt {{ ansible_distribution_release }}-2ndquadrant main"
# Add the following variable in order to install a specific version from 2nd Quadrant repos using apt.
# repmgr_version_debian: 

# Replication
repmgr_primary: false
repmgr_config_directory: "{{ postgresql_conf_directory }}"
repmgr_replication_user: "{{ repmgr_user }}"
repmgr_replication_type: physical
repmgr_location: default
repmgr_use_replication_slots: "no"
repmgr_witness_sync_interval: 15
repmgr_use_primary_conninfo_password: "false"
repmgr_passfile: /var/lib/postgresql/.pgpass
repmgr_base_key_path: /var/lib/postgresql/.ssh
repmgr_private_key_path: /var/lib/postgresql/.ssh/id_rsa
repmgr_public_key_path: /var/lib/postgresql/.ssh/id_rsa.pub
repmgr_ssh_key_bits: 2048
repmgr_ssh_key_type: rsa
repmgr_ssh_force_renewal: false

# Logging
repmgr_log_level: INFO
repmgr_log_facility: STDERR
repmgr_log_file: /var/lib/postgresql/repmgrd.log
repmgr_log_status_interval: 300

# Notification
repmgr_event_notification_command: ""
repmgr_event_notifications: ""

# Directories
repmgr_pg_bindir: "{{ postgresql_bin_directory }}"
repmgr_repmgr_bindir: "{{ postgresql_bin_directory }}"

# Commands & options
repmgr_pg_ctl_options: ""
repmgr_pg_basebackup_options: ""
repmgr_rsync_options: ""
repmgr_tablespace_mapping: ""
repmgr_restore_command: ""
repmgr_archive_cleanup_command: ""
repmgr_recovery_min_apply_delay: ""
repmgr_ssh_options: "-o StrictHostKeyChecking=no"

# Intervals & timeouts
repmgr_promote_check_timeout: 60
repmgr_promote_check_interval: 1
repmgr_primary_follow_timeout: 60
repmgr_standby_follow_timeout: 30
repmgr_standby_follow_restart: "false"
repmgr_shutdown_check_timeout: 60
repmgr_standby_reconnect_timeout: 60
repmgr_node_rejoin_timeout: 60

# Barman
repmgr_barman_host: ""
repmgr_barman_port: 22
repmgr_barman_user: barman
repmgr_barman_server: ""
repmgr_barman_config: ""
repmgr_repmgrd_pid_file: ""

# Fail-over
repmgr_failover: manual
repmgr_priority: 100
repmgr_connection_check_type: ping # Accepted: ping, connection, query
repmgr_reconnect_attempts: 6
repmgr_reconnect_interval: 10
repmgr_promote_command: ""
repmgr_follow_command: ""
repmgr_primary_notification_timeout: 60
repmgr_repmgrd_standby_startup_timeout: 60
repmgrd_exit_on_inactive_node: "false"

# Monitoring
repmgr_monitoring_history: "no"
repmgr_keep_history_days: 2 # used by the 'repmgr cluster cleanup' command which is to be executed by a cronjob. See configure_repmgr.yml
repmgr_monitor_interval_secs: 2
repmgr_degraded_monitoring_timeout: -1
repmgr_async_query_timeout: 60

# Advanced failover parameters (new in version 5.x)
repmgr_standby_disconnect_on_failover: "false"
repmgr_sibling_nodes_disconnect_timeout: 30
repmgr_primary_visibility_consensus: "false"
repmgr_always_promote: "false"
repmgr_failover_validation_command: ''
repmgr_election_rerun_interval: 15
repmgr_child_nodes_check_interval: 5
repmgr_child_nodes_connected_min_count: -1
repmgr_child_nodes_disconnect_min_count: -1
repmgr_child_nodes_disconnect_timeout: 30
repmgr_child_nodes_disconnect_command: ''

# Service commands
repmgr_service_start_command: pg_ctlcluster {{ postgresql_version }} {{ postgresql_cluster_name }} start
repmgr_service_stop_command: pg_ctlcluster {{ postgresql_version }} {{ postgresql_cluster_name }} stop
repmgr_service_restart_command: pg_ctlcluster {{ postgresql_version }} {{ postgresql_cluster_name }} restart
repmgr_service_reload_command: pg_ctlcluster {{ postgresql_version }} {{ postgresql_cluster_name }} reload
repmgr_service_promote_command: /usr/lib/postgresql/{{ postgresql_version }}/bin/pg_ctl -w -D {{ postgresql_data_directory }} promote

# Warning levels
repmgr_archive_ready_warning: 16
repmgr_archive_ready_critical: 128
repmgr_replication_lag_warning: 300
repmgr_replication_lag_critical: 600

# repmgrd configuration
repmgrd_service_start_command: systemctl start repmgrd
repmgrd_service_stop_command: systemctl stop repmgrd