[Pgpool-general] README: proposed patch

[Thomas F. O'Connell]

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)