[pgpool-general: 8828] Re: Starting pgpool does not automatically start postgresql

[Bo Peng]

Hi,

On Mon, 12 Jun 2023 16:00:25 +0800
Zhaoxun Yan <yan.zhaoxun at gmail.com> wrote:

> Hi guys!
> 
> I tried to start pgpool by  `pgpool -nd` but only to find what it started
> are just a number of waiting for connections, logger, pcp and worker
> process. It seems not cared at all on whether there is a postgresql service
> on or not. It is because I have not configured failover_command or
> something like that?

PostgreSQL won't be automatically started when pgpool starts.
Before starting pgpool, you need to start PostgreSQL first.

> BTW, is it necessary to enlarge ` num_init_children` amount for better
> service or it may add in more subprocess once it find connection request is
> larger than expected?

By default (process_management_mode = static), Pgpool-II will prefork child processes
which is specified in "num_init_children".
Pgpool-II will not accept more requests than specified in "num_init_children".

If you are using Pgpool-II 4.4, You can use the dynamic mode ("process_management_mode = dynamic") to dynamically spawn processes when requests increase.

Doc:
https://www.pgpool.net/docs/latest/en/html/runtime-config-process-management.html

-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
https://www.sraoss.co.jp/