[pgpool-general: 2677] Re: dont start

[Alexandru Cardaniuc]

Thomaz Luiz Santos <thomaz.santos at gmail.com> writes:

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


Are you running pgpool as root?


-- 
"God created the integers; all the rest is the work of man." 
- Leopold Kronecker