> Hi people, > > We have a setup using Slony-I that currently consists of 1 origin server with > 2 subscribers. I'd like to use pgpool to manage connections in Master/Slave > Mode, however looking at the docs (http://pgpool.projects.postgresql.org/) > theres not that much info on this. > > The docs state: > > "This mode is for using pgpool-II with another master/slave replication > software (like Slony-I), so it really does the actual data replication. DB > nodes' information must be set as the replication mode. In addtion to that, > set master_slave_mode and load_balance_mode to true." > > And I'm afraid I just can't get my head around exactly what I'm supposed to > do from that, I could do with a little more verbose instruction. > > I've tried pgpool, and just set it up in Connection Pool Mode and it works > well. I guess we could just use it in this mode, then in the case we move > our set or failover we just repoint the pool. However, the Master/Slave Mode > sounds very interesting. > > Is there anywhere I can get better info on setting up this mode?
Sorry for the poor documentations. Actually the settings for using master/slave mode is surprisingly simple. If you are running Slony master on host foo port 5432 and a slave on host bar port 5433, the settings for pgpool.conf would look something like: backend_hostname0 = 'foo' backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '/usr/local/pgsql/data' backend_hostname1 = 'bar' backend_port1 = 5433 backend_weight1 = 1 backend_data_directory1 = '/usr/local/pgsql/data' replication_mode = false master_slave_mode = true load_balance_mode = true In the master/slave mode, pgpool will throw all DMLs to master only. SELECTs will be thrown to master and slave. Hope this helps, -- Tatsuo Ishii SRA OSS, Inc. Japan _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
