[Pgpool-general] README: proposed patch

Tatsuo Ishii ishii at sraoss.co.jp
Sun Oct 23 12:28:46 GMT 2005


Thanks. I have added it to README (and Japanese translation added to
README.euc_jp) on CVS tips.
--
SRA OSS, Inc. Japan
Tatsuo Ishii

> Tatsuo,
> 
> I'd like to propose this as an addendum to the pgpool README:
> 
> 15. Multiple simultaneous instances of pgpool
> 
> In order to run multiple instances of pgpool on the same server 
> simultaneously (in order to have two separate, non-conflicting  
> connection pools, for instance), create a different configuration  
> file for each instance of pgpool you wish to run.
> 
> Then start each instance of pgpool by using the -f flag to point it  
> to the correct configuration file. For instance:
> 
> pgpool -f /usr/local/etc/pgpool.1.conf
> pgpool -f /usr/local/etc/pgpool.2.conf
> 
> In order for the separate instances to run without conflict, make  
> sure that the following parameters are different in the configuration  
> files:
> 
> port
> logdir (which currently controls where pgpool drops a pid file)
> 
> Note that each instance of pgpool should then be stopped by  
> specifying the -f flag, too. For instance:
> 
> pgpool -f /usr/local/etc/pgpool.1.conf -m smart stop
> 
> This would stop the first instance of pgpool running in this example.
> 
> --
> Thomas F. O'Connell
> Co-Founder, Information Architect
> Sitening, LLC
> 
> Open Source Solutions. Optimized Web Development.
> 
> http://www.sitening.com/
> 110 30th Avenue North, Suite 6
> Nashville, TN 37203-6320
> 615-469-5150
> 615-469-5151 (fax)



More information about the Pgpool-general mailing list