[Pgpool-general] inconsistency when using two pgpool instances in warm standby?

[Edward Pilipczuk]

[cut]

I have deployed PgPool working under control of heartbeat 2.1.4 (v2 - by use
of CRM).

- heartbeat config file (/etc/ha/d/ha.cf)

use_logd yes
keepalive 10
deadtime 60
warntime 20
initdead 60
ucast eth1 10.60.70.245
auto_failback on
node cbs01 cbs02
crm respawn

- cib.xml defines the following pgpool group of resources:

       <group id="PGP">
         <primitive class="ocf" id="PGPOOL_IPaddr" provider="heartbeat"
type="IPaddr">
           <operations>
             <op id="PGPOOL_IPaddr_mon" interval="20s" name="monitor"
timeout="5s"/>
           </operations>
           <instance_attributes id="PGPOOL_IPaddr_inst_attr">
             <attributes>
               <nvpair id="PGPOOL_IPaddr_attr_0" name="ip" value="
10.60.70.247"/>
               <nvpair id="PGPOOL_IPaddr_attr_2" name="cidr_netmask"
value="28"/>
               <nvpair id="PGPOOL_IPaddr_attr_3" name="broadcast" value="
10.60.70.255"/>
             </attributes>
           </instance_attributes>
         </primitive>
         <primitive class="ocf" id="PGPOOL" provider="heartbeat"
type="PgPool">
           <operations>
             <op id="PGPOOL_mon" interval="120s" name="monitor"
timeout="20s"/>
             <op id="PGPOOL_start" name="start" timeout="600s"/>
           </operations>
         </primitive>
       </group>

- primitive resource PGPOOL is controlled by the OCF script (see attached
file)
- OCF scripts use parameters from /etc/pgpool.conf (see atteched file) and
it uses PCP commands
 to attach/detach/recovery/... operations on backend databases.

This provides running single (hence synchronized) pgpool instance accessed
via virtual IP address that migrates together with pgpool over cluster nodes
in case failure occurs . OCF script is bothering on attaching/detaching the
underlying backends (with data synchronization if required) when
starting/stopping the pgpool instance.

I can prepare ./contrib/ branch of heartbeat configuration resources to the
2.2 relese if you are interested in.

regards,
Edward Pilipczuk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20081212/46b9ebb6/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PgPool
Type: application/octet-stream
Size: 7112 bytes
Desc: not available
Url : http://pgfoundry.org/pipermail/pgpool-general/attachments/20081212/46b9ebb6/attachment.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 5814 bytes
Desc: not available
Url : http://pgfoundry.org/pipermail/pgpool-general/attachments/20081212/46b9ebb6/attachment-0001.obj