[pgpool-general: 4713] Re: pgpool-ha-3.0

[TAKATSUKA Haruka]

Hi.

Please see pgpool-II log.
I expect the reason not to be able to start pgpool-II will be there.

> >  stderr: DEBUG: PgPool: PIDFILE /var/run/pgpool/pgpool.pid doesn't exist

This is an unnecessary message but harmless.



with regards,
_____________________________________
TAKATSUKA Haruka harukat at sraoss.co.jp


On Mon, 6 Jun 2016 12:19:42 +0300
Kirill Galinurov <k.galinurov at gmail.com> wrote:

> Hi all, i try to configure pgpool-ha 3.0 on Centos 7.2. I install resource
> file
> 
> install -m 0755 -o root -g root \
>     ./pgpool.in  /usr/lib/ocf/resource.d/heartbeat/pgpool
> 
> Then i try to create resource.

> pcs resource create PgPool ocf:heartbeat:pgpool
> pgpoolconf=/etc/pgpool-II/pgpool.conf pcpconf=/etc/pgpool-II/pcp.conf
> hbaconf=/etc/pgpool-II/pool_hba.conf logfile=/var/log/pgpool.log
> pgpooluser=postgres checkmethod=pcp checkstring="-w -h localhost -p 9898"
> psqlcmd=/usr/bin/psql pgpoolcmd=/usr/bin/pgpool
> pcpnccmd=/usr/bin/pcp_node_count op monitor interval=30s
> 
> But when i try to start pgpool ignoring parametrs.
> 
> I change default parametrs in  /usr/lib/ocf/resource.d/heartbeat/pgpool.
> And after that pgpoll started.
> tcp        0      0 0.0.0.0:9898            0.0.0.0:*               LISTEN
>      3003/pgpool
> tcp        0      0 0.0.0.0:9999            0.0.0.0:*               LISTEN
>      3003/pgpool
> 
> ls /var/run/pgpool/
> pgpool.pid
> 
> But pcs resource show listing is
> pgPool (ocf::heartbeat:pgpool):        Stopped
> 
> pcs resource debug-start PgPool
> Operation start for PgPool (ocf:heartbeat:pgpool) returned 0


> >  stderr: INFO: PgPool: nohup /usr/bin/pgpool -f
> /etc/pgpool-II/pgpool.conf -a /etc/pgpool-II/pool_hba.conf -F
> /etc/pgpool-II/pcp.con
> f  -n >> /var/log/pgpool.log 2>&1 & AS postgres
> >  stderr: DEBUG: PgPool: PIDFILE /var/run/pgpool/pgpool.pid doesn't exist

> >  stderr: DEBUG: PgPool: not started yet, waiting
> >  stderr: DEBUG: PgPool: start returned 0
> 
> What is wrong? What is the recommended architecture for pgpool-3.5 high
> availability?