| Both sides previous revision Previous revision | |
| postgresql_repmgr_installation [2021/09/28 11:28] – [Automatic Failover] andonovj | postgresql_repmgr_installation [2021/09/28 11:30] (current) – andonovj |
|---|
| repmgr_bindir='/usr/lib/postgresql/12/bin' # Path to repmgr binary directory (location of the repmgr | repmgr_bindir='/usr/lib/postgresql/12/bin' # Path to repmgr binary directory (location of the repmgr |
| use_primary_conninfo_password=false # explicitly set "password" in "primary_conninfo" | use_primary_conninfo_password=false # explicitly set "password" in "primary_conninfo" |
| passfile='/var/lib/postgresql/12/main/.pgpass' # path to .pgpass file to include in "primary_conninfo" | passfile='/var/lib/postgresql/12/main/.pgpass' # path to .pgpass file to include in "primary_conninfo" |
| ssh_options='-o StrictHostKeyChecking=no' # Options to append to "ssh" | ssh_options='-o StrictHostKeyChecking=no' # Options to append to "ssh" |
| promote_check_timeout=60 # The length of time (in seconds) to wait | promote_check_timeout=60 # The length of time (in seconds) to wait |
| reconnect_attempts=6 # Number of attempts which will be made to reconnect to an unreachable | reconnect_attempts=6 # Number of attempts which will be made to reconnect to an unreachable |
| reconnect_interval=10 # Interval between attempts to reconnect to an unreachable | reconnect_interval=10 # Interval between attempts to reconnect to an unreachable |
| promote_command='repmgr standby promote -f /etc/repmgr.conf --log-to-file' # command repmgrd executes when promoting a new primary; use something like: | promote_command='repmgr standby promote -f /etc/repmgr.conf --log-to-file' # command repmgrd executes when promoting a new primary; use something like: |
| follow_command='repmgr standby follow -f /etc/repmgr.conf --log-to-file --upstream-node-id=%n' # command repmgrd executes when instructing a standby to follow a new primary; | follow_command='repmgr standby follow -f /etc/repmgr.conf --log-to-file --upstream-node-id=%n' # command repmgrd executes when instructing a standby to follow a new primary; |
| primary_notification_timeout=60 # Interval (in seconds) which repmgrd on a standby | primary_notification_timeout=60 # Interval (in seconds) which repmgrd on a standby |