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

Alexandru Cardaniuc cardaniuc at gmail.com
Tue Jun 10 04:20:40 JST 2014


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


More information about the pgpool-general mailing list