I use Aurora postgreSQL cluster on AWS.
I attempted failover test on aurora postgreSQL, but a few connections still alive on read cluster.
I want to reconnect all connections to new writer cluster immediately!!
I want to use
select result from (SELECT pg_is_in_recovery() as result) as t where result='f'; for validation query.
Can I use my own validation query on postgreSQL?
Please help me…!!!