Postgresql Streaming Replication on Windows failover

Question

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 ?

• Laurenz Albe: Do you want to access the standby or do you want to fail over? Please be more specific.
• Anisa Ibro: Thank You for your reply. I want to access standby ( Its critical for me to use the standby as master and have available database for read/write.
• Laurenz Albe: Do you want to promote the standby? Your question is still unclear.
• Anisa Ibro: Yes i want to promote the standy

Answer 1

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();