[Pgpool-general] multiple pools

[Tatsuo Ishii]

> I'd like to run multiple connection poolers on a single machine to connect
> to numerous slaves in a replication pool.  How would I go about getting
> multiple instances of pgpool running on a single box ?

That's pretty easy.

1) create pgpool.conf for each pgpool instance.

2) each pgpool.conf must have different values for following
   directives:

   port
   logdir

Example:

#1 instance: pgpool -f /etc/pgpoo1.conf
#2 instance: pgpool -f /etc/pgpoo2.conf

/etc/pgpool1.conf:

port = 9001
logdir = /var/pgpool1
:
:

/etc/pgpool2.conf:

port = 9002
logdir = /var/pgpool2
:
:
--
Tatsuo Ishii
SRA OSS, Inc. Japan