<div dir="ltr"><div>I'm trying to make a postgresql cluster using pgpool watchdog but I am unable to activate pgpool or by pgpooladmin </div><div><br></div><div>by console, I try to start and had this message </div><div>
<br></div><div>ubuntu 13</div><div>pgpool 3.2</div><div>postgres 9.1 ( stream replication active )</div><div>pgpoolAdmin 3.2</div><div>apache2</div><div>php5</div><div><br></div><div><br></div><div>on SLAVE:</div><div><br>
</div><div><div>root@slave:~$ pgpool -D -n -d</div></div><div>20.03.2014 13:41:17 LOG: pid 1866: wd_chk_sticky: ifup [/ sbin / ifconfig] does not have the sticky bit </div><div>20.03.2014 13:41:17 LOG: pid 1866: Backend file / var / log status / pgpool / pgpool_status does not exist </div>
<div>03/20/2014 13:41:17 ERROR: pid 1866: bind (/ var/run/postgres/.s.PGSQL.9999) failed. reason: No such file or directory </div><div>03/20/2014 13:41:17 ERROR: pid 1866: unlink (/ var/run/postgres/.s.PGSQL.9999) failed: No such file or directory </div>
<div>03/20/2014 13:41:17 ERROR: pid 1866: unlink (/ var/run/postgres/.s.PGSQL.9898) failed: No such file or directory </div><div>03/20/2014 13:41:17 ERROR: pid 1866: Could not open file / var status / log / pgpool / pgpool_status </div>
<div>20.03.2014 13:41:17 DEBUG: pid 1866: shmem_exit (1) </div><div><br></div><div><br></div><div>on MASTER:</div><div><div><div>root@master:~$ pgpool -D -n -d</div></div><div><br></div><div>2014-03-20 13:50:43 LOG: pid 2268: wd_chk_sticky: ifup[/sbin/ifconfig] doesn't have sticky bit</div>
<div>2014-03-20 13:50:43 LOG: pid 2268: Backend status file /var/log/pgpool/pgpool_status does not exist</div><div>2014-03-20 13:50:43 ERROR: pid 2268: bind(/var/run/postgres/.s.PGSQL.9999) failed. reason: No such file or directory</div>
<div>2014-03-20 13:50:43 ERROR: pid 2268: unlink(/var/run/postgres/.s.PGSQL.9999) failed: No such file or directory</div><div>2014-03-20 13:50:43 ERROR: pid 2268: unlink(/var/run/postgres/.s.PGSQL.9898) failed: No such file or directory</div>
<div>2014-03-20 13:50:43 ERROR: pid 2268: Could not open status file /var/log/pgpool/pgpool_status</div><div>2014-03-20 13:50:43 DEBUG: pid 2268: shmem_exit(1)</div></div><div><br></div><div><br></div><div>I'm using this tutorial </div>
<div><a href="http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave/en.html">http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave/en.html</a></div><div><br></div>-- <br>------------------------------<br>
Thomaz Luiz Santos<br>Linux User: #359356<br><a href="http://thomaz.santos.googlepages.com/">http://thomaz.santos.googlepages.com/</a>
</div>