[pgpool-general: 2322] Re: cannot execute INSERT in a read-only transaction
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.
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.
SRA OSS, Inc. Japan
More information about the pgpool-general