Postgresql Streaming Replication on Windows failover
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

SELECT pg_promote();