© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
Search
Star
Feedback
Setup for Free
S
Supabase
•
4y ago
courtstarr
Read-only transaction error
I am attempting to insert data and get the following error
:
"cannot execute INSERT in a read
-only transaction
"
I found this via Google
https://www.postgresql.r2schools.com/postgresql-error-cannot-execute-in-a-read-only-transaction/
but how do I get access to the files they specify
(e
.g
. standby
.signal
, recovery
.signal
)
Is my database in recovery mode
? It isn
't clear via the Supabase UI
.
PostgreSQL Tutorials and Solutions
admin
PostgreSQL Error: cannot execute in a read-only transaction | Postg...
PostgreSQL Error
: cannot execute in a read
-only transaction
Supabase
Join
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816
Members
View on Discord
Resources
ModelContextProtocol
ModelContextProtocol
MCP Server
Similar Threads
Was this page helpful?
Yes
No
Recent Announcements
Similar Threads
cannot execute DELETE in a read-only transaction
S
Supabase / help-and-questions
4y ago
Ran - "ALTER DATABASE postgres SET default_transaction_read_only = on;"
S
Supabase / help-and-questions
3w ago
Read-Only Naughty Step
S
Supabase / help-and-questions
5mo ago
Connection times out in Transaction mode only
S
Supabase / help-and-questions
7d ago