[pgpool-general: 6343] Re: Pgpool is not accepting any new connections

[Juan Carlos Michaca]

Hi Pierre;

Thanks for your reply.

Currently I have just 2 connections in  pg_stat_activity, and
num_init_children is set to 32 in pgpool.conf.

I set num_init_children to 50 and problem persists, I should restart pgpool
force it to accept connections.

I share my pgpool.conf

Regards.



On Thu, Dec 13, 2018 at 8:33 AM Pierre Timmermans <ptim007 at yahoo.com> wrote:

> Hi
>
> The most common reason for that is when the parameter num_init_children is
> too low: when there are more connections to postgres than num_init_children
> then pgpool does not give an error but it refuses (or it queues it maybe)
> without giving an error.
>
> So count the number of connection (from pg_stat_activity) and if it is
> equal to num_init_children then you have the answer...
>
> Pierre
>
>
> On Thursday, December 13, 2018, 2:13:52 AM GMT+1, Juan Carlos Michaca <
> jcmichaca at vinkos.com> wrote:
>
>
> Hi all,
>
> I am testing pgpool in this scenario
>
> Pgpool A(Master) + PG Backend A (primary)
>
> Pgpool B(Standby) + PG Backend B (replica with streaming replication)
>
> At this point I'm able to run queries to pgpool from any address in my
> network.
>
>
> If I shut down Pgpool A(Master) and its PG Backend (primary), Pgpool B(now
> master) is not accepting any connections until I restart it.
>
>
> After restarting Pgpool B(now master) I can connect to pgpool from any
> host and run queries.
>
> Please, can you help to figure out what's could be wrong?
>
> Regards
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20181213/a41369b3/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 35888 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20181213/a41369b3/attachment-0001.obj>