[pgpool-general: 5960] Re: pgpool load balancing problem

Tatsuo Ishii ishii at sraoss.co.jp
Thu Mar 1 13:23:33 JST 2018

> I found a problem that had a big impact on our servers. I'm using pgpool as
> a load balancer and pool connections manager. When a user tries to run a
> select query it redirects the query to the slave. If the user tries after
> that to run dml or ddl command he get error :
> ERROR: cannot execute CREATE TABLE in a read-only transaction
> SQL state: 25006
> Is there any way to solve this issue ? It means that once the pool
> redirected your session to the slaves you cant run any ddl/dml actions ..

Normaly Pgpool-II redirects any ddl/dml query to primary.  Can you
show me following query results? I would like to confirm your problem.

show pool_version;
show pool_nodes;

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