[pgpool-hackers: 4453] Re: Pgpool PCP get disabled. How it is possible?

[Tatsuo Ishii]

> Hi Tatsuo,
> Thanks for the answer.
> Hmm... AFAIR, pcp socket usually is available on either master and standby
> nodes.

Assuming "master" and "standby" mean watchdog master and standby, pcp
socket are available on both master and standby. More precisely, pcp
sockets are created by pcp main process, which is a child process of
pgpool main process.

> What is the motivation of waiting for a primary node before creating a PCP
> port?

Pgpool-II recommends to start PostgreSQL before Pgpool-II starting up
because Pgpool-II needs to monitor and control load balancing and
failover. If Pgpool-II user follow the guide line, find_primary_node
should not take too long and pcp port will be soon available. But if
the user does not follow the guide line, Pgpool-II needs to wait
before PostgreSQL starting up (and starts streaming replication).

If you don't want to wait the pcp port availability, you can tweak
search_primary_node_timeout.

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp