[Pgpool-general] Re: PGPool suggestion

[Magnus Naeslund(w)]

Tatsuo Ishii wrote:
>
> Ok, I think I found a solution. I have committed following changes
> in CVS. Please grab and try it.
>
> It works like this:
>
> 1) a pgpool child process finds "DROP DATABASE" command
>
> 2) it sends HUP signal to parent pgpool and wait for 5 seconds
>
> 3) the parent pgpool sends HUP to all child pgpool
>
> 4) each child pgpool receives the signal and releases all idle
>    connections to PostgreSQL
>
> 5) the child pgpool(1) sends DROP DATABASE command to PostgreSQL
>
> What do you think?

Thanks for working on this, this will enable us to remove shell acess to
people that shouldn't have it!
I'll try this on later today...

Another question I have: will pgpool use the new pg 8.1 two phase commit
to implement loadbalancing/replication?

Am I missing anything when I'm saying this would make for a really robust
loadbalancing solution with changes going to all servers?
Or are there troubles going with this approach?

Regards
Magnus