> 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
