On Mon, May 10, 2010 at 8:59 PM, John R Pierce <pie...@hogranch.com> wrote: > Scott Marlowe wrote: >>> >>> Is there any sort of abstraction layer (like in the driver level) that >>> can abstract that and just make updates go to one DB and reads >>> round-robin to other DBs? Hopefully there's a way to make this design >>> simple to implement. >>> >> >> Pretty sure pgpool can do the "read from these dbs, write to this one". >> > > > how would it know if you're going to do updates later on in a transaction?
Go here: http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html look for replicate_select -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
