[Pgpool-general] failover with slony

[Pomarede Nicolas]

On Fri, 20 Jan 2006, Christopher Gorge Marges wrote:

> When the master in a master/slave setup goes down will pgpool
> automatically switch to the slave? The documentation in slony said
> that pgpool would need to be restarted.  Also since failover is not
> automatic in slony, wouldn't that also prevent continuous access to
> the database?
>
> I would also like to ask what the following line in pgpoool.conf is for:
>
> # if child_max_connections connections were received, child exits. 0
> means no exit.
> child_max_connections = 10
>
> Does this mean each child process counts how many connections it
> creates and after it makes 10 connections then it will exit?

Hello,

this means the child will exit after processing 10 connections. Just after 
exiting, it will be forked again by the main slony process. So the number 
of available processes remain the same.

This setting is useful to avoid possible loss of ressource when a pgpool 
process stays connected for too long to the database (bigger values should 
be used, for example 1000 ; 10 could force too frequent forks and degrade 
performance).


----------------
Nicolas Pomarede                   e-mail:   npomarede at corp.free.fr

"In a world without walls and fences, who needs windows and gates ?"