© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3w ago•
2 replies
GARREC Gildas

Database stuck in read-only mode despite low disk usage (9%)

🔢DB Connections
Ticket: SU-315010
Project: FOURMIZ (Pro Plan - Micro instance)
Region: West EU (Paris)

Problem

My database is stuck in read-only mode and I cannot write anything.

Details

- Disk usage: 1.85 GB / 20 GB (only 9%)
- Error:
cannot execute ALTER TABLE in a read-only transaction
cannot execute ALTER TABLE in a read-only transaction

- PostgREST logs:
could not make a writable connection to server
could not make a writable connection to server


What I tried (nothing worked)

- ❌ Restart project (multiple times)
- ❌ SQL commands:
set default_transaction_read_only = 'off'
set default_transaction_read_only = 'off'

- ❌ Pause project (asks for payment even on Pro plan)
- ❌ Increased disk from 12GB to 20GB

Context

The disk was previously full (12GB/12GB), which triggered read-only mode.
I increased to 20GB and cleaned data, but read-only flag is still active.

Request

Please manually disable the read-only flag on my database.

Thank you! 🙏
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

Database entered Read only mode
SupabaseSSupabase / help-and-questions
14mo ago
Database stuck in recovery mode, cannot resize disk
SupabaseSSupabase / help-and-questions
2mo ago
Database Monthly usage only
SupabaseSSupabase / help-and-questions
3y ago
Storage quota exceeded warning despite low bucket usage
SupabaseSSupabase / help-and-questions
2mo ago