Re: Pgpool questions

Brian Maguire wrote:
> I have a couple Pgpool questions regarding running pgpool as a load balancer with Sony as the replicator.
> 
>  
> 
> Is there anyway to load balance selects to more than 2 servers? ex.  1 master with 2 slaves?  Run multiple instances?

My understanding is that if you turn on the load balancing it will 
automatically do so for all servers.

> 
> Is there any way to tell a select (ex. with a function) to go only the master and not the slave?

Run it in a transaction with BEGIN;

> 
> Is there any way to tell a select query to only go to the slave?  

That i don't know.

Sincerely,

Joshua D. Drake
Command Prompt, Inc.

> 
>  
> 
> Thanks
> 
>  
> 
>  
> 
> 
> ---------------------------(end of broadcast)---------------------------TIP 5: Have you checked our extensive FAQ?
>                http://www.postgresql.org/docs/faq