Thread: pgpool

pgpool

From
"Brian Maguire"
Date:

Is anyone currently using pgpool with production high volume use?  I am interested in your success and challenges.

 

Brian

Re: pgpool

From
Peter Eisentraut
Date:
Brian Maguire wrote:
> Is anyone currently using pgpool with production high volume use?  I
> am interested in your success and challenges.

There isn't much special about high volume use.  Just make sure you
configure the pool size appropriately for your application and
configure a corresponding number of connection slots in the PostgreSQL
server.  Note that pgpool has not authentication mechanism of its own,
so you need to firewall it or confine it to the local machine.  It may
also be worthwhile to include both pgpool and the PostgreSQL server in
some sort of monitoring application, say, Nagios.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/