On 18/08/2023 11:34, Emile Amewoto wrote:
Hi Lejeczek, What are you using to control your cluster?
If you are using patroni, you can use regex to grep the Leader or if you are not using any cluster manager you can do:
SELECT Count(pid))
FROM pg_stat_activity WHERE wait_event IS NOT NULL AND backend_type = ‘walsender'
The master will always have walsender process and the standby walreiver
Regards,
Emile
Hi guys.
Is it possible to configure pgSQL to announce it's being a master and not querying it?
I was hoping for a file whose existence or content would confirm that and would be generated/created by pqSQL itself - am I too naive?
many thanks, L.
Hi, thanks for the tip.
I'm looking at what I wrote - perhaps I was bit vague -
... it's being a master by not querying it & via means of config/uration instead - is what wanted to ask.