Cannot set transaction read-write mode during recovery error

Question

I try to insert row:

BEGIN;
  SET TRANSACTION READ WRITE; 
INSERT INTO soft.lk(time_added, expiration_date)
    VALUES (now(), now() + INTERVAL '730 days');
COMMIT;

But have following error:

cannot set transaction read-write mode during recovery

What is recovery. And how can i insert row? Postgres version: 9.0

Answer 1

You have connected to a read-replica server in hot standby mode - a streaming replica, or one that's using WAL archiving, it doesn't matter.

These servers are read-only. So you cannot write to them.

Connect to the master server instead.