Re: Pgpool starting problem - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: Pgpool starting problem
Date
Msg-id 20140509.092517.1977550671371351027.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Pgpool starting problem  (Jay at Verizon <jayknowsunix@gmail.com>)
List pgsql-general
> Hi all,
>
> If I turn use_watchdog = off in the pgpool.conf file, then in spite of the
> system being configured as master-slave, a socket file is created in /tmp,
> and everything starts normally with no errors. If, however, I set
> use_watchdog = on, pgpool will abort on startup with the following errors:
>
> 2014-05-08 14:40:22 ERROR: pid 32893: watchdog: wd_init failed
> 2014-05-08 14:40:22 ERROR: pid 32893: wd_main error
> 2014-05-08 14:40:22 ERROR: pid 32893: unlink(/tmp/.s.PGSQL.9898) failed: No
> such file or directory
>
> It seems pretty consistent doing this, and I can flip use_watchdog on and
> off and the same behavior repeating. Any ideas?

You didn't give any pgpool version, configuration file info, I cannot
guess what's going on. There's a detailed installation document here:

http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html

Despite you follow the instruction you still have problems, you should ask pgpool ML.

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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Receiving many more rows than expected
Next
From: Michael Paquier
Date:
Subject: Re: How to fix lost synchronization with server