Index

Symbols

.pgpass, Using a password file

A

always_promote, Optional configuration for automatic failover
archive_command
PostgreSQL configuration, PostgreSQL configuration for repmgr
archive_mode
PostgreSQL configuration, PostgreSQL configuration for repmgr

B

Barman
cloning a standby, Cloning a standby from Barman
fetching archived WAL, Using Barman as a WAL file source

C

cascading replication
repmgrd, repmgrd and cascading replication
CentOS
package information, CentOS Packages
child_nodes_check_interval
child node disconnection monitoring, Standby disconnections monitoring process configuration
child_nodes_connected_include_witness
child node disconnection monitoring, Standby disconnections monitoring process configuration
child_nodes_connected_min_count
child node disconnection monitoring, Standby disconnections monitoring process configuration
child_nodes_disconnect_command
child node disconnection monitoring, Standby disconnections monitoring process configuration
event notification, Standby disconnections monitoring process event notifications
child_nodes_disconnect_min_count
child node disconnection monitoring, Standby disconnections monitoring process configuration
child_nodes_disconnect_timeout
child node disconnection monitoring, Standby disconnections monitoring process configuration
child_node_disconnect
event notification, Standby disconnections monitoring process event notifications
child_node_new_connect
event notification, Standby disconnections monitoring process event notifications
child_node_reconnect
event notification, Standby disconnections monitoring process event notifications
cloning
advanced options, Advanced cloning options
cascading replication, Cloning and cascading replication
from Barman, Cloning a standby from Barman
replication slots, Cloning and replication slots
using passwords, Managing passwords
compatibility matrix, repmgr compatibility matrix
concepts, Concepts
configuration
database user permissions, repmgr database user permissions
PostgreSQL, PostgreSQL configuration for repmgr
prerequisites, Prerequisites for configuration
repmgr.conf, Configuration file
ssh, Prerequisites for configuration
config_directory configuration file parameter, Optional configuration file settings
connection_check_type, repmgrd configuration
conninfo configuration file parameter, Required configuration file settings

D

data_directory configuration file parameter, Required configuration file settings
Debian/Ubuntu
package information, Debian/Ubuntu Packages
repmgrd daemon configuration, repmgrd daemon configuration on Debian/Ubuntu
degraded monitoring, "degraded monitoring" mode
degraded_monitoring_timeout, repmgrd configuration

E

election_rerun_interval, Optional configuration for automatic failover
event notifications, Event Notifications

F

failover, Required configuration for automatic failover
failover validation, Failover validation
failover_validation_command, Optional configuration for automatic failover
FAQ (Frequently Asked Questions), FAQ (Frequently Asked Questions)
fencing
using repmgrd and pgbouncer to fence a failed primary node, Configuring repmgrd and pgbouncer to fence a failed primary node
Following a new primary, Following a new primary
(see also repmgr standby follow)
follow_command, Required configuration for automatic failover

H

hot_standby
PostgreSQL configuration, PostgreSQL configuration for repmgr

I

installation, Installation
from packages, Installing repmgr from packages
from source, Installing repmgr from source
old package versions, Installing old package versions
on Debian/Ubuntu etc., Debian/Ubuntu
on Red Hat/CentOS/Fedora etc., RedHat/CentOS/Fedora
requirements, Requirements for installing repmgr

L

location configuration file parameter, Optional configuration file settings
log rotation
repmgrd, repmgrd log rotation
log settings
configuration in repmgr.conf, Log settings
log_facility configuration file parameter, Log settings
log_file configuration file parameter, Log settings
log_level configuration file parameter, Log settings
log_status_interval configuration file parameter, Log settings

M

max_replication_slots
PostgreSQL configuration, PostgreSQL configuration for repmgr
max_wal_senders
PostgreSQL configuration, PostgreSQL configuration for repmgr
monitoring
repmgrd, repmgrd daemon monitoring
with repmgrd, Storing monitoring data
monitor_interval_secs, repmgrd configuration

N

network splits, Handling network splits with repmgrd
node_id configuration file parameter, Required configuration file settings
node_name configuration file parameter, Required configuration file settings
node_rejoin_timeout
with "repmgr standby switchover", Configuration file settings

P

packages, repmgr package details
CentOS packages, CentOS Packages
Debian/Ubuntu packages, Debian/Ubuntu Packages
information for packagers, Information for packagers
old versions, Installing old package versions
snapshots, Snapshot packages
passwords, Password Management
options for managing, Password Management Options
using a password file, Using a password file
pausing repmgrd, Pausing the repmgrd service
PgBouncer
using repmgrd and pgbouncer to fence a failed primary node, Configuring repmgrd and pgbouncer to fence a failed primary node
pgpass, Using a password file
pg_bindir configuration file parameter, Optional configuration file settings
pg_ctlcluster
service command settings, Service command settings
pg_rewind
configuration file retention, pg_rewind and configuration file retention, Example using repmgr node rejoin and pg_rewind
using with "repmgr node rejoin", Using pg_rewind
using with "repmgr standby switchover", Switchover and pg_rewind
pg_upgrade, pg_upgrade and repmgr
PID file
repmgrd, repmgrd's PID file
PostgreSQL 9.4
repmgr support, PostgreSQL 9.4 support
PostgreSQL configuration, PostgreSQL configuration for repmgr
primary_visibility_consensus, Primary visibility consensus, Optional configuration for automatic failover
priority, Optional configuration for automatic failover
promote_check_interval
with "repmgr standby promote ", Configuration file settings
promote_check_timeout
with "repmgr standby promote ", Configuration file settings
promote_command, Required configuration for automatic failover
promoting a standby, Promoting a standby server with repmgr
(see also repmgr standby promote)

Q

quickstart, Quick-start guide

R

reconnect_attempts, repmgrd configuration
reconnect_interval, repmgrd configuration
recovery.conf
customising with "repmgr standby clone", Customising replication configuration
generating for a standby cloned by another method, Using a standby cloned by another method
Release notes, Release notes
replication configuration
customising with "repmgr standby clone", Customising replication configuration
generating for a standby cloned by another method, Using a standby cloned by another method
replication slots
cloning, Cloning and replication slots
replication_lag_critical
with "repmgr standby switchover", Configuration file settings
replication_type configuration file parameter, Optional configuration file settings
replication_user configuration file parameter, Optional configuration file settings
repmgr
compatibility matrix, repmgr compatibility matrix
repmgr cluster cleanup, repmgr cluster cleanup
repmgr cluster crosscheck, repmgr cluster crosscheck
repmgr cluster event, repmgr cluster event
repmgr cluster matrix, repmgr cluster matrix
repmgr cluster show, repmgr cluster show
repmgr daemon start, repmgr daemon start
repmgr daemon stop, repmgr daemon stop
repmgr node check, repmgr node check
repmgr node rejoin, repmgr node rejoin
caveats, Caveats when using repmgr node rejoin
repmgr node service, repmgr node service
repmgr node status, repmgr node status
repmgr primary register, repmgr primary register
repmgr primary unregister, repmgr primary unregister
repmgr service pause, repmgr service pause
repmgr service status, repmgr service status
repmgr service unpause, repmgr service unpause
repmgr standby clone, repmgr standby clone
(see also cloning)
repmgr standby follow, repmgr standby follow
repmgr standby promote, repmgr standby promote
repmgr standby register, repmgr standby register
repmgr standby switchover, repmgr standby switchover
repmgr standby unregister, repmgr standby unregister
repmgr witness register, repmgr witness register
(see also witness server)
repmgr witness unregister, repmgr witness unregister
repmgr.conf, Configuration file
format, Configuration file format
include directives, Configuration file include directives
location, Configuration file location
log settings, Log settings
optional settings, Optional configuration file settings
PostgreSQL major version upgrades, Configuration file and PostgreSQL major version upgrades
required settings, Required configuration file settings
service command settings, Service command settings
repmgrd
applying configuration changes, Applying configuration changes to repmgrd
automatic failover, Automatic failover with repmgrd
cascading replication, repmgrd and cascading replication
child node disconnection, Monitoring standby disconnections on the primary node
configuration, repmgrd setup and configuration
Debian/Ubuntu and daemon configuration, repmgrd daemon configuration on Debian/Ubuntu
degraded monitoring, "degraded monitoring" mode
displaying service status, repmgr service status
failover validation, Failover validation
log rotation, repmgrd log rotation
monitoring, repmgrd daemon monitoring, Storing monitoring data
monitoring configuration, Monitoring configuration
network splits, Handling network splits with repmgrd
operation, repmgrd operation
overview, repmgrd overview
paused WAL replay, repmgrd and paused WAL replay
pausing, Pausing the repmgrd service, repmgr service pause
PID file, repmgrd's PID file
PostgreSQL service configuration, PostgreSQL service configuration
primary visibility consensus, Primary visibility consensus
repmgrd service configuration, repmgrd service configuration
standby disconnection, Monitoring standby disconnections on the primary node
standby disconnection on failover, Standby disconnection on failover
starting, repmgr daemon start
starting and stopping, repmgrd daemon
stopping, repmgr daemon stop
unpausing, repmgr service unpause
witness server, Using a witness server
repmgrd_exit_on_inactive_node, Optional configuration for automatic failover
repmgrd_service_start_command
with "repmgr daemon start", Configuration file settings
repmgrd_service_stop_command
with "repmgr daemon stop", Configuration file settings

S

service command settings
configuration in repmgr.conf, Service command settings
service_promote_command
with "repmgr standby promote ", Configuration file settings
shutdown_check_timeout
with "repmgr standby switchover", Configuration file settings
sibling_nodes_disconnect_timeout, Optional configuration for automatic failover
snapshot packages, Snapshot packages
ssh_options configuration file parameter, Optional configuration file settings
standby disconnection on failover, Standby disconnection on failover
standby_disconnect_on_failover, Optional configuration for automatic failover
standby_reconnect_timeout
with "repmgr standby switchover", Configuration file settings
support, repmgr support
reporting issues, Reporting Issues
switchover, Performing a switchover with repmgr
caveats, Caveats
execution, Executing the switchover command
preparation, Preparing for switchover
troubleshooting, Troubleshooting switchover issues

T

tablespace mapping, Tablespace mapping

U

upgrading, Upgrading repmgr
checking repmgrd status, Checking repmgrd status after an upgrade
from repmgr 3.x, Upgrading from repmgr 3.x
major release, Upgrading a major version release
minor release, Upgrading a minor version release
pg_upgrade, pg_upgrade and repmgr
repmgr 4.x and later, Upgrading repmgr 4.x and later
use_replication_slots configuration file parameter, Optional configuration file settings

W

wal_keep_segments
PostgreSQL configuration, PostgreSQL configuration for repmgr
wal_keep_size
PostgreSQL configuration, PostgreSQL configuration for repmgr
wal_level
PostgreSQL configuration, PostgreSQL configuration for repmgr
wal_log_hints
PostgreSQL configuration, PostgreSQL configuration for repmgr
wal_receive_check_timeout
with "repmgr standby switchover", Configuration file settings
witness server
repmgrd, Using a witness server