[pgpool-general: 6617] Re: pgpool status

[Martin Goodson]

On 26/06/2019 11:52, Lakshmi Raghavendra wrote:
> HI Pgpool Team,
> 
>                   I am using pgpool in my production environment.
> Wanted to know if there is any command by which I can fetch the pgpool 
> status.
> Basically from the logs we can see the different phases like LOADING to 
> INITIATLIZING..finally to master. So is there any command which will 
> tell me, if pgpool started (became master / or joined the existing 
> cluster successfully).
> 
> Also any command to tell me the current pgpool master.
> I have seen that the "show pool nodes" command tells me the postgres 
> status of all the nodes in the cluster. Similarly wanting to know the 
> pgpool status.
> 
> Please let me know.
> 
> Thanks And Regards,
> 
>      Lakshmi Y M
> 
Unless I'm missing something obvious, surely pcp_watchdog_info gives you 
that?


M.

-- 
Martin Goodson

"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?"
"Bung a rock at it."