Postgres Pro
Downloads
Home   >   mailing lists

Thread: [GENERAL] PGpool question

[GENERAL] PGpool question

From
Andrew Kerber
Date:
This may be the wrong list, but I am not sure where it needs to go.  I am trying to set up pgpool, and I keeping on getting this message:

NOTICE:  add node from hostname:"xxxxxxx" port:9000 pgpool_port:9999 rejected.
Jul 28 22:11:49 xxxxxx pgpool[10768]: [172-2] 2017-07-28 22:11:49: pid 10768: DETAIL:  verify the other watchdog node configurations
Jul 28 22:11:49 xxxxx pgpool[10768]: [172-3] 2017-07-28 22:11:49: pid 10768: LOCATION:  watchdog.c:1481

I believe I have mismatched settings for the watchdog configuration, but I cannot find them.  I have debugging turned all the way up, but nothing is telling me what setting is the problem,  Is there any way I can figure out what specific watchdog setting its complaining about?


--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Re: [GENERAL] PGpool question

From
Tatsuo Ishii
Date:
> This may be the wrong list, but I am not sure where it needs to go.  I am
> trying to set up pgpool, and I keeping on getting this message:
>
> NOTICE:  add node from hostname:"xxxxxxx" port:9000 pgpool_port:9999
> rejected.
> Jul 28 22:11:49 xxxxxx pgpool[10768]: [172-2] 2017-07-28 22:11:49: pid
> 10768: DETAIL:  verify the other watchdog node configurations
> Jul 28 22:11:49 xxxxx pgpool[10768]: [172-3] 2017-07-28 22:11:49: pid
> 10768: LOCATION:  watchdog.c:1481
>
> I believe I have mismatched settings for the watchdog configuration, but I
> cannot find them.  I have debugging turned all the way up, but nothing is
> telling me what setting is the problem,  Is there any way I can figure out
> what specific watchdog setting its complaining about?

Muhammad Usama kindly followed the question:
------------------------------------------------------------------------
The message refers to the configuration mismatch of other_pgpool_* config
parameter,
The one defined in section  5.14.9. Watchdog servers configurations
<http://www.pgpool.net/docs/latest/en/html/runtime-watchdog-config.html> of
the documentation.
So you need to check the other_pgpool_hostname, other_pgpool_port or
other_wd_port
config values.
------------------------------------------------------------------------
If you have further questions, please post to pgpool-general@pgpool.net.

https://www.pgpool.net/mailman/listinfo/pgpool-general

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp