[pgpool-general: 1666] Re: pgpool fails to start under pgpool-ha

[Theodotos Andreou]

Found it. The default pgpool.conf in Ubuntu has /var/run/postgresql/ as 
the socket dir and pid location. But for some reason this is created by 
the relevant pgpool sysv scrict on start and erased on stop! So if you 
start pgpool without the ubuntu sysv startup script the 
/var/lib/postgresql directory is not created and so pgpool fails to start.

I resorted in using the /tmp as socket and pid directory. It works now. 
So if you want to use ha on ubuntu you may need to do the same.


On 04/27/2013 07:19 AM, Theodotos Andreou wrote:
> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general