[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