Postgresql Streaming Replication on Windows failover

failoverhigh-availabilitymaster-slave-replicationpostgresqlreplication

Hello i have setup streaming replication using PostgreSQL 11 on Windows working OK.
How can i manually use the replica ( it is hot_standby=on ) in case Master fails ?
What are the steps i have to perform to the replica ?

Best Answer

Like the documentation says, there are three ways to promote a standby server:

  1. run pg_ctl promote on the command line.

  2. create a trigger file (if you have configured the standby server accordingly).

  3. from v12 on, you can also execute

    SELECT pg_promote();