[pgpool-general: 2322] Re: cannot execute INSERT in a read-only transaction

Tatsuo Ishii ishii at postgresql.org
Tue Dec 3 10:58:18 JST 2013

> I have pgpool setup with streaming replication and master/slave. I got the following error
> cannot execute INSERT in a read-only transaction
> after this query in the psql client
> INSERT INTO test (testa, testb, testc) VALUES ('hi','hi','hi');
> I couldn't find a solution online. Some threads suggested black list functions but I wasn't sure if that was the avenue to pursue.
> Thanks 		 	   		  

Please provide pgpool.conf, pgpool log and PostgreSQL log (both master
and slave). Also are you sure that if you can execute the INSERT if
you directory connect to PostgreSQL master.
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

More information about the pgpool-general mailing list