[Pgpool-general] Several instances of pgpool simultaneously

ariabushenko at eerc.kiev.ua ariabushenko at eerc.kiev.ua
Mon Feb 11 13:30:44 UTC 2008


I am planning to use pgpool for load-balancing and fail-over in  
multi-master  db cluster, but one thing thing stops me from doing  
that. I can't find a way to launch several pgpools. In order to avoid  
single point of failure and to reduce network lattency, I want to give  
each node its own pgpool instance.

The documention says that several instances of pgpool can't work  
together in replication mode, because one instace of pgpool will  
continue to send queries when other one is replicating. Is there a way  
to tell other instances of pgpool to suspend their activity, while  
replicating? Possibly to send STOP and CONTINUE signals using some  
shell script? Can I use PCP for that task?

Or I can use some other replication facility not the one that pgpool  
has. Is there other replicators available that can work in sync  
multi-master environment?





More information about the Pgpool-general mailing list