You should raise your questions with the folks on the pgpool list. Slony people probably aren't the right audience to discuss pgpool mods with. A couple quick points though -
On Thu, 2007-01-18 at 18:20 -0800, Christian Storm wrote: > Right now, if I understand it right, pgpool will 'stick' SELECT > statements to the master if they are in a transaction block. Correct. > Otherwise, they go > to the slave. As I'm sure you know, this can cause problems when > SELECT queries are run against the slave and the data hasn't arrived yet > due to the replication lag. That problem doesn't exist if you put your queries inside a transaction. They will never go to a subscriber. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp. _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
