Hello all, I've been using PgPoolI with success for some time now, but noticed that development on it is (understandably) waning, so I've decided to give PgPoolII a try.
I can't seem to get a basic setup to work as expected, though. My test setup: -------------- 1 master, multiple slaves. Skytools for replication. Slaves: PG listening on 5431, pgpoolII listening on 5432 Master: Pg listening on 5432 Requirement: ------------ SELECTs must *only* occur on the localhost (ie, on slave). INSERTS/UPDATES/DELETES must go to the master. Config on slaves: ----------------- listen_addresses = '*' port = 5432 replication_mode = false load_balance_mode = true replicate_select = false master_slave_mode = true connection_cache = true pgpool2_hostname = 'slave1' # what is this? slave||master hostname? backend_hostname0 = 'master' backend_port0 = 5432 backend_weight0 = 0 backend_data_directory0 = '/data' backend_hostname1 = 'slave1' backend_port1 = 5431 backend_weight1 = 1 backend_data_directory1 = '/data' SELECT statements keep going to the master and not slave1. INSERT statments are not going to the master, and instead are being executed on slave1... I must be misunderstanding something basic here. My setup is similar to Michael SALOMON's ([Pgpool-general] Problem with load balancing + automatic failover), without failover. Any comments or suggestions are welcome. Thanks Henry _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
