Hi,
We are trying to get pgpool working in replication mode with load balancing. There are a few questions we're trying to find answers to: - Does pgpool detect data mismatches by executing the queries on all backends and comparing the results? If so, how does this work with query load balancing turned on (i.e. queries are only sent to one backend)? - In PostgreSQL, INSERT statements increment sequence numbers (using serial primary keys) even if they fail. In such cases, would the failed statement get executed on all backends? If not, how does pgpool prevent a data mismatch on the sequence? Any help would be appreciated. Regards, Anthony _________________________________ Anthony MacKinnon Software Architect Waypoint Information Technology Inc. Office: 613.224.9376 ext.17 Mobile: 613.867.5344 www.waypointinfo.com
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
