ยฉ 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabaseโ€ข3y agoโ€ข
5 replies
Roland

How to delete/reset database?

I guessed that "postgres" is the database that shoudl be used.
before restorign I have
dropdb   -U postgres --if-exists  postgres -w -h "$SUPA_URL"
dropdb   -U postgres --if-exists  postgres -w -h "$SUPA_URL"


to which I get

dropdb: error: database removal failed: ERROR: database "postgres" is being accessed by other users
DETAIL: There are 4 other sessions using the database.

There's no 4 users! I am only one and I am not accesing it.
I couldn't find any option to reset or even erase it. Do I have to delete whole project?
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

How to delete Edge function?
SupabaseSSupabase / help-and-questions
3mo ago
How to delete using .match ?
SupabaseSSupabase / help-and-questions
4y ago
Reset database from Project web GUI
SupabaseSSupabase / help-and-questions
4y ago
**URGENT HELP NEEDED** I think i delete/reset all the data from by database
SupabaseSSupabase / help-and-questions
6mo ago