[Pgpool-general] Several instances of pgpool simultaneously

Yoshiyuki Asaba y-asaba at sraoss.co.jp
Tue Feb 12 01:58:41 UTC 2008


Hi,

From: ariabushenko at eerc.kiev.ua
Subject: [Pgpool-general] Several instances of pgpool simultaneously
Date: Mon, 11 Feb 2008 15:30:44 +0200

> 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. 

This restriction is for online-recovery.


> 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?

You cannot suspend pgpool in current version... However, I'm planning
to implement suspending function using PCP protocol.

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp


More information about the Pgpool-general mailing list