[pgpool-general: 5181] Re: Fedora 24 adding pgpool to system services

[Avi Weinberg]

Hi,

If you can connect with port 5432 and not with 9999 it means your pgpool and postgres connection configuration do not match (you defined more connections to postgres than the connections you defined for pgpool connection pool).

The relevant parameters in pgpool.conf  are:  num_init_children and max_pool
The relevant parameters in postgresql.conf are max_connections  and superuser_reserved_connections.

If you cannot get it to work you can temporarily disable pgpool connection pool with  connection_cache = off until you figure out the right configuration

Avi
From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Vola Maminiaina Nirina Andriamiadana
Sent: Monday, December 19, 2016 2:50 PM
To: Mikola Rose <mrose at power-soft.net>
Cc: pgpool-general at pgpool.net
Subject: [pgpool-general: 5178] Re: Fedora 24 adding pgpool to system services


Hello Mikola and Vlad,
 I have a big problem after configuring my pgpool I can't connect
 to port 9999 but I can connect to 5432 very well
Please help me! :(
2016-12-15 3:18 GMT+03:00 Mikola Rose <mrose at power-soft.net<mailto:mrose at power-soft.net>>:
Awesome ,  thanks Vlad



On Dec 14, 2016, at 4:17 PM, Vlad Novikov <xou.slackware at gmail.com<mailto:xou.slackware at gmail.com>> wrote:

Well then you'll need to write a unit file and register the service with chkconfig. Otherwise you can take an existing unit file from older RPM and modify it appropriately. If you're going to create those from scratch, google with keywords "unit files" and "systemd". In fact, that's more Linux question rather than pgpool-II related.

On Mon, Dec 12, 2016 at 9:45 PM, Mikola Rose <mrose at power-soft.net<mailto:mrose at power-soft.net>> wrote:
Thanks for the pointer but I was using 3.6 src to trouble shoot some issues I was having.

On Dec 12, 2016, at 8:57 PM, Vlad Novikov <xou.slackware at gmail.com<mailto:xou.slackware at gmail.com>> wrote:
If 3.6.0 is not critical, you can just install pgpool-II 3.5.4 from PostgreSQL official repository (https://download.postgresql.org/pub/repos/yum/9.4/fedora/fedora-24-x86_64/). It'll configure unit scripts and make it run as a system service.

On Fri, Dec 9, 2016 at 4:16 PM, Mikola Rose <mrose at power-soft.net<mailto:mrose at power-soft.net>> wrote:
Hi list users,


Can anyone suggest or point me in the right direction on how to configure pgpool 3.6.0 as a system service on fedora 24.

thnx
Mik
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>
http://www.pgpool.net/mailman/listinfo/pgpool-general

_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>
http://www.pgpool.net/mailman/listinfo/pgpool-general



_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>
http://www.pgpool.net/mailman/listinfo/pgpool-general

IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161220/ecfd07cd/attachment.html>