On Tue, Aug 18, 2015 at 12:53 PM, Jaime Casanova <jaime.casan...@2ndquadrant.com> wrote: > This is not completely true, you can always use something like > pgbouncer or other middleware to change the server to which clients > connect. you still need to solve the fact that you will have a > read-only server at the other side. > > something like repmgr + pgbouncer will work fine.
Sure, but pgbouncer is an extra hop, and has its own foibles. There's real appeal to doing this in the client. > i agree that once/if we ever have multimaster included then this could > be a good idea I think it has a lot of appeal *now*. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
