[Pgpool-general] Multiple Instances of pgpool

[Tatsuo Ishii]

> Is it possible to run multiple instances of pgpool on the same server?

Sure. Why not.

> If I have two different clusters of application servers that I want  
> to throttle separately in terms of postgres access but don't want  
> them competing with one another, it seems like it would be useful to  
> have pgpool run as determine by two separate configuration files, but  
> I currently don't seem to be able to start multiple separate instance  
> of pgpool.

If you have two separate configuration files, you need to specify them
by -f option. Example:

instance 1: pgpool -f /etc/pgpool1.conf
instance 2: pgpool -f /etc/pgpool2.conf

In pgpool1.conf and pgpool2.conf following directives should have
different values:

port
socket_dir
logdir

Hope this helps,
--
SRA OSS, Inc. Japan
Tatsuo Ishii