[pgpool-general: 1665] pgpool fails to start under pgpool-ha

Theodotos Andreou theo at ubuntucy.org
Sat Apr 27 13:19:48 JST 2013


Hi guys,

I have setup a pgpool-ii node which works OK when standalone. I try to 
setup a second one for HA. I use corosynd/pacemaker. I use this command 
to activate pgpool under the cluster:

# crm configure primitive pgPool ocf:heartbeat:pgpool params logfile=/var/log/postgresql/pgpool

But it fails to start. These are the logs:

http://pastebin.com/JkmaL6nE

Besides these 3 lines I do not see anything else useful:

Apr 27 06:58:56 node-dbpool01 pgpool(pgPool)[6283]: INFO: pgPool: /usr/sbin/pgpool -f /etc/pgpool2/pgpool.conf  AS postgres
Apr 27 06:58:56 node-dbpool01 lrmd: [1093]: info: operation start[12] on pgPool for client 1096: pid 6283 exited with return code 0
Apr 27 06:58:56 node-dbpool01 crmd: [1096]: info: process_lrm_event: LRM operation pgPool_start_0 (call=12, rc=0, cib-update=158, confirmed=true) ok


I am using pgpool-ha 2.0 and pgpool-ii v3.1.3 from ubuntu 13.04 
repositories:

# pgpool -v
pgpool-II version 3.1.3 (hatsuiboshi)

Any idea what I am doing wrong? I couldn't find any step by step guide 
for pgpool-ha.

Regards

theo


More information about the pgpool-general mailing list