[Pgpool-general] pgpool-ha issues

Nikolay Popov nikolay.popov at altima.com.ua
Sat Oct 10 02:49:45 UTC 2009


Hello

I'm trying to set up a pgpool-II 2.2.5 with heartbeat 2.1.3-6lenny4 and 
pgpool-ha-1.2 scripts.
As directed in documentation, I performed ./configure; cd src; make && 
make install, put cib.xml int /var/lib/heartbeat/crm and fix ha.cf and 
other stuff at well.
Currently I'm trying to get thing up only at one master node1.
Heartbeat starting, detects that node1 is online, but no ip alias nor 
pgpool starts.
That's what confuses me, founded in /var/log/messages:

Oct 10 04:43:44 debian-dhcp01 pengine: [7257]: WARN: native_color: 
Resource resource_ip cannot run anywhere
Oct 10 04:43:44 debian-dhcp01 pengine: [7257]: WARN: native_color: 
Resource resource_pgpool2 cannot run anywhere

Could anybody point me on correct way to get things up? Configuration in 
pgpool-ha seems to be outdated a bit:
"There's sample cib.xml file.
* Modify 'node1' and 'node2' to your hostname, '192.168.0.3' to your 
floating IP address ."
but there is nothing about 'node2' in cib.xml at all...
Maybe there is another more easy way to monitor pgpool with heartbeat?

Thanks in advance
Regards, Nikolay


More information about the Pgpool-general mailing list