[pgpool-general: 6946] Re: PGPool Native Replication for unnamed prepared statements

Tatsuo Ishii 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.

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list