© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
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 Solutionsadmin
PostgreSQL Error: cannot execute in a read-only transaction | Postg...
PostgreSQL Error: cannot execute in a read-only transaction
PostgreSQL Error: cannot execute in a read-only transaction | Postg...
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

cannot execute DELETE in a read-only transaction
SupabaseSSupabase / help-and-questions
4y ago
Ran - "ALTER DATABASE postgres SET default_transaction_read_only = on;"
SupabaseSSupabase / help-and-questions
3w ago
Read-Only Naughty Step
SupabaseSSupabase / help-and-questions
5mo ago
Connection times out in Transaction mode only
SupabaseSSupabase / help-and-questions
7d ago