[pgpool-general: 6946] Re: PGPool Native Replication for unnamed prepared statements
ishii at sraoss.co.jp
Sat Apr 4 16:00:51 JST 2020
> I've been unable to get pgpool to replicate unnamed prepared statements (IE
> parameterized queries) across the back-ends.It appears that pgpool sends
> the query through to the primary backend and not the others. Is this
> intentional, a bug, or am I perhaps missing a configuration setting
> somewhere? Any help is appreciated. I've observed this is pgpool 3.5.6 as
> well as 4.0.4.
Depends on the query. SELECTs are sent to the master node only unless
replicate_select is on. DML/DDL are sent to all backends.
If you see DML/DDL are sent to the master node only, please provide
the concrete query.
SRA OSS, Inc. Japan
More information about the pgpool-general