[pgpool-general: 6109] Re: target_session_attrs

Christophe Pettus xof at thebuild.com
Wed May 30 11:57:39 JST 2018

> On May 29, 2018, at 17:24, Mario V <mariovikale at hotmail.com> wrote:
> How does pgpool compare with the new v10 feature target_session_attrs
> for routing writes to the primary and reads to the standby?

They're very different.  target_session_attrs is only at time of connection, in which it will pick one server (from a list) with a particular set of attributes.  Once that connection is established, it doesn't change unless you close and reopen the connection.  Thus, if you open the connection asking for a server that can take writes, you get the master, and all queries sent down that connection go to the master.  There's no equivalent of pgpool2's per-query routing.

-- Christophe Pettus
   xof at thebuild.com

More information about the pgpool-general mailing list