About backups in supabase

From my understanding backups are only for pro users, however, I was wondering if there was a way to manually backup my database? That's question #1, question #2 is do backups include the functions/triggers that I've made as well ? or is it just the tables? My project relies heavily on the triggers I've made.
4 Replies
silentworks
silentworks4mo ago
It includes anything that is stored in the database. You can backup manually using pg_dump as you have access to your database connection string.
Rasan II
Rasan IIOP4mo ago
Thank you for the quick response is there any documentation/article/video tutorial on how pg_dump can be safely done ?
silentworks
silentworks4mo ago
It's a Postgres feature so a quick google search should bring you some results.
Rasan II
Rasan IIOP4mo ago
awesome thank you, you can close this as resolved

Did you find this page helpful?