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

[Pierre Timmermans]

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/74e01f4d/attachment-0001.html>