[Pgpool-general] Using replication with a load balanced configuration

[Tatsuo Ishii]

> Is it possible to configure pgpool-ii to replicate all queries by 
> default (select/updates/inserts) and, only on some queries (select), do 
> a load balance? I think that the closest way to do this is to configure 
> pgpool.conf like this:
> 
> replication_mode = true
> load_balance_mode = true
> replicate_select = false

This setting does exactly what you want.

> And using "/*REPLICATION*/" directive on all queries except when I want 
> load balancing. Is there another way to do this? We don't want to send 
> the "/*REPLICATION*/" prefix on all our queries.

You don't need this.
--
Tatsuo Ishii
SRA OSS, Inc. Japan