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 ?
PostgreSQL – Setting Up Streaming Replication and Failover on Windows
failoverhigh-availabilitymaster-slave-replicationpostgresqlreplication
Related Question
- Postgresql – Streaming Replication in PostgreSQL
- Postgresql – changing server roles in streaming replication
- Streaming Replication Between PostgreSQL 9.2 and 9.3
- Postgresql – Streaming replication – STONITH
- Postgresql Streaming replication – monitoring
- Postgresql – Testing postgresql 9.4 streaming replication
Best Answer
Like the documentation says, there are three ways to promote a standby server:
run
pg_ctl promote
on the command line.create a trigger file (if you have configured the standby server accordingly).
from v12 on, you can also execute