Index

Symbols

.pgpass, Using a password file

A

always_promote, Optional configuration for automatic failover
archive_command
LightDB configuration, LightDB configuration for ltcluster
archive_mode
LightDB configuration, LightDB configuration for ltcluster

C

cascading replication
ltclusterd, ltclusterd and cascading replication
check_lightdb_command, Optional configuration for check LightDB
check_lightdb_interval, Optional configuration for check LightDB
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
replication slots, Cloning and replication slots
using passwords, Managing passwords
concepts, Concepts
configuration
database user permissions, ltcluster database user permissions
LightDB, LightDB configuration for ltcluster
ltcluster.conf, Configuration file
prerequisites, Prerequisites for configuration
ssh, Prerequisites for configuration
config_directory configuration file parameter, Optional configuration file settings
connection_check_type, ltclusterd configuration
conninfo configuration file parameter, Required configuration file settings

D

data_directory configuration file parameter, Required configuration file settings
Debian/Ubuntu
ltclusterd daemon configuration, ltclusterd daemon configuration on Debian/Ubuntu
degraded monitoring, "degraded monitoring" mode
degraded_monitoring_timeout, ltclusterd 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
fencing
using ltclusterd and pgbouncer to fence a failed primary node, Configuring ltclusterd and pgbouncer to fence a failed primary node
Following a new primary, Following a new primary
(see also ltcluster standby follow)
follow_command, Required configuration for automatic failover

H

hot_standby
LightDB configuration, LightDB configuration for ltcluster

L

LightDB configuration, LightDB configuration for ltcluster
location configuration file parameter, Optional configuration file settings
log rotation
ltclusterd, ltclusterd log rotation
log settings
configuration in ltcluster.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
ltcluster cluster cleanup, ltcluster cluster cleanup
ltcluster cluster crosscheck, ltcluster cluster crosscheck
ltcluster cluster event, ltcluster cluster event
ltcluster cluster matrix, ltcluster cluster matrix
ltcluster cluster show, ltcluster cluster show
ltcluster daemon start, ltcluster daemon start
ltcluster daemon stop, ltcluster daemon stop
ltcluster node check, ltcluster node check
ltcluster node rejoin, ltcluster node rejoin
caveats, Caveats when using ltcluster node rejoin
ltcluster node service, ltcluster node service
ltcluster node status, ltcluster node status
ltcluster primary register, ltcluster primary register
ltcluster primary unregister, ltcluster primary unregister
ltcluster service pause, ltcluster service pause
ltcluster service status, ltcluster service status
ltcluster service unpause, ltcluster service unpause
ltcluster standby clone, ltcluster standby clone
(see also cloning)
ltcluster standby follow, ltcluster standby follow
ltcluster standby promote, ltcluster standby promote
ltcluster standby register, ltcluster standby register
ltcluster standby switchover, ltcluster standby switchover
ltcluster standby unregister, ltcluster standby unregister
ltcluster witness register, ltcluster witness register
(see also witness server)
ltcluster witness unregister, ltcluster witness unregister
ltcluster.conf, Configuration file
format, Configuration file format
include directives, Configuration file include directives
LightDB major version upgrades, Configuration file and LightDB major version upgrades
location, Configuration file location
log settings, Log settings
optional settings, Optional configuration file settings
required settings, Required configuration file settings
service command settings, Service command settings
ltclusterd
applying configuration changes, Applying configuration changes to ltclusterd
automatic failover, Automatic failover with ltclusterd
cascading replication, ltclusterd and cascading replication
child node disconnection, Monitoring standby disconnections on the primary node
configuration, ltclusterd setup and configuration
Debian/Ubuntu and daemon configuration, ltclusterd daemon configuration on Debian/Ubuntu
degraded monitoring, "degraded monitoring" mode
displaying service status, ltcluster service status
failover validation, Failover validation
LightDB service configuration, LightDB service configuration
log rotation, ltclusterd log rotation
ltclusterd service configuration, ltclusterd service configuration
monitoring, Storing monitoring data
monitoring configuration, Monitoring configuration
network splits, Handling network splits with ltclusterd
operation, ltclusterd operation
overview, ltclusterd overview
paused WAL replay, ltclusterd and paused WAL replay
pausing, Pausing the ltclusterd service, ltcluster service pause
PID file, ltclusterd's PID file
primary visibility consensus, Primary visibility consensus
standby disconnection, Monitoring standby disconnections on the primary node
standby disconnection on failover, Standby disconnection on failover
starting, ltcluster daemon start
starting and stopping, ltclusterd daemon
stopping, ltcluster daemon stop
unpausing, ltcluster service unpause
witness server, Using a witness server
ltclusterd_service_start_command
with "ltcluster daemon start", Configuration file settings
ltclusterd_service_stop_command
with "ltcluster daemon stop", Configuration file settings
lt_rewind
configuration file retention, lt_rewind and configuration file retention, Example using ltcluster node rejoin and lt_rewind
using with "ltcluster node rejoin", Using lt_rewind
using with "ltcluster standby switchover", Switchover and lt_rewind

M

max_replication_slots
LightDB configuration, LightDB configuration for ltcluster
max_wal_senders
LightDB configuration, LightDB configuration for ltcluster
monitoring
with ltclusterd, Storing monitoring data
monitor_interval_secs, ltclusterd configuration

N

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

P

passwords, Password Management
options for managing, Password Management Options
using a password file, Using a password file
pausing ltclusterd, Pausing the ltclusterd service
PgBouncer
using ltclusterd and pgbouncer to fence a failed primary node, Configuring ltclusterd and pgbouncer to fence a failed primary node
pgpass, Using a password file
pg_ctlcluster
service command settings, Service command settings
PID file
ltclusterd, ltclusterd's PID file
primary_visibility_consensus, Primary visibility consensus, Optional configuration for automatic failover
priority, Optional configuration for automatic failover
promote_check_interval
with "ltcluster standby promote ", Configuration file settings
promote_check_timeout
with "ltcluster standby promote ", Configuration file settings
promote_command, Required configuration for automatic failover
promoting a standby, Promoting a standby server with ltcluster
(see also ltcluster standby promote)

Q

quickstart, Quick-start guide

R

reconnect_attempts, ltclusterd configuration
reconnect_interval, ltclusterd configuration
recovery.conf
customising with "ltcluster standby clone", Customising replication configuration
generating for a standby cloned by another method, Using a standby cloned by another method
replication configuration
customising with "ltcluster 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 "ltcluster standby switchover", Configuration file settings
replication_type configuration file parameter, Optional configuration file settings
replication_user configuration file parameter, Optional configuration file settings

S

service command settings
configuration in ltcluster.conf, Service command settings
service_promote_command
with "ltcluster standby promote ", Configuration file settings
shutdown_check_timeout
with "ltcluster standby switchover", Configuration file settings
sibling_nodes_disconnect_timeout, Optional configuration for automatic failover
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 "ltcluster standby switchover", Configuration file settings
switchover, Performing a switchover with ltcluster
caveats, Caveats
execution, Executing the switchover command
preparation, Preparing for switchover
troubleshooting, Troubleshooting switchover issues

T

tablespace mapping, Tablespace mapping

U

use_replication_slots configuration file parameter, Optional configuration file settings

W

wal_keep_segments
LightDB configuration, LightDB configuration for ltcluster
wal_keep_size
LightDB configuration, LightDB configuration for ltcluster
wal_level
LightDB configuration, LightDB configuration for ltcluster
wal_log_hints
LightDB configuration, LightDB configuration for ltcluster
wal_receive_check_timeout
with "ltcluster standby switchover", Configuration file settings
witness server
ltclusterd, Using a witness server