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

alice cook alicecookfan2012 at hotmail.com
Tue Dec 3 10:32:50 JST 2013


Hi,
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 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20131202/b9ba14e0/attachment.html>


More information about the pgpool-general mailing list