[pgpool-general: 4712] pgpool-ha-3.0

Kirill Galinurov k.galinurov at gmail.com
Mon Jun 6 18:19:42 JST 2016


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: DEBUG: PgPool: PIDFILE /var/run/pgpool/pgpool.pid doesn't exist
>  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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160606/a64a4be7/attachment.html>


More information about the pgpool-general mailing list