Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Hello everybody <:supafire:979110896762757121> 
I'm connected to the DB from my machine but if i try to do a backup (pg_dump), it says I don't have enough permissions. I'm connected with the postgres credentials in a free project. 
am I doing it wrong?, or do I need a Pro project?, or even like that is it not possible at all to backup my database? thanks!

Hello <@762595693994049557>!
This thread has been automatically created from your message in <#843999948717555735> a few seconds ago.

We have already mentioned the <@&951828363943759883> so that they can see your message and help you as soon as possible!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates.

**Want to change the title?**
Use the ``/title`` command!

**We have solved your problem?**
Click the button below to archive it.

You might need to elevate the postgres user before doing the `pg_dump`, you can do this with the command below from inside of the Supabase Dashboard using the SQL Editor 
```sql
ALTER USER postgres WITH SUPERUSER;
```
After the `pg_dump` has completed, remember to go back in the SQL Editor and de-elevate the postgres user.
```sql
ALTER USER postgres WITH NOSUPERUSER;
```

<@107176742342402048> thanks a lot!!! <:supafire:979110896762757121>

Thread was archived by <@762595693994049557>. Anyone can send a message to unarchive it.