In this article, we will see the solution for error like PostgreSQL Error: cannot execute in a read-only transaction.
ERROR: cannot execute CREATE DATABASE in a read-only transaction Error: cannot execute DROP DATABASE in a read-only transaction ERROR: cannot execute CREATE TABLE in a read-only transaction Error: cannot execute DROP TABLE in a read-only transaction cannot execute INSERT in a read-only transaction
Reason:
Reason is simple, PostgreSQL server is in recovery(read-only) or standby mode.
Resolution:
1. We have to remove recovery(read-only) or standby mode.
2. Go to your data or main directory then remove standby.signal and recovery.signal files.
Before performing following action, take backup of these files in some other location.
File location in(Ubuntu change your respective version nuymber)
/var/lib/postgresql/13/main
3. After removing signal files, restart PostgreSQL cluster.
sudo systemctl restart postgresql
4. Then, you will able to connect to the server and perform all actions as usual.