27.2. Log-Shipping Standby Servers

27.2.1. Planning
27.2.2. Standby Server Operation
27.2.3. Preparing the Primary for Standby Servers
27.2.4. Setting Up a Standby Server
27.2.5. Streaming Replication
27.2.6. Replication Slots
27.2.7. Cascading Replication
27.2.8. Synchronous Replication
27.2.9. Continuous Archiving in Standby

Continuous archiving can be used to create a high availability (HA) cluster configuration with one or more standby servers ready to take over operations if the @@ -103,7 +103,7 @@ later disconnected, the standby goes back to step 1 and tries to restore the file from the archive again. This loop of retries from the archive, pg_wal, and via streaming replication goes on until the server - is stopped or failover is triggered by a trigger file. + is stopped or is promoted.

Standby mode is exited and the server switches to normal operation when pg_ctl promote is run, @@ -654,4 +654,4 @@ synchronous_standby_names = 'ANY 2 (s1, s2, s3)' are found in the archive, but not if streaming replication is enabled. When a server is not in recovery mode, there is no difference between on and always modes. -

Prev	Up	Next
27.1. Comparison of Different Solutions	Home	27.3. Failover