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

[Tatsuo Ishii]

> 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
Japanese:http://www.sraoss.co.jp