[pgpool-general: 2907] how to easily find the master backend

[Alexandru Cardaniuc]

Hi,

I have a cluster of 2 PostgreSQL 9.3 databases using streaming
replication managed by a cluster of 2 Pgpool 3.3.3 (using watchdog). To
identy the primary pgpool I can run pcp_watchdog_info command, which
will give me the IP of the server that primary pgpool is running on right now.

What's the best way to easily find the master backend database in that
setup? I need for instance to go and make some changes on the master
backend and want to know which of the 2 databases in the cluster is the
master at this point.

thanks,
Alexandru

-- 
"In language, clarity is everything."  
- Confucius