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

Supabase

I ran the command

grant all on auth.identities to postgres, dashboard_user;

Yet I still get

pg_dump: error: query failed: ERROR:  permission denied for table schema_migrations
pg_dump: error: query was: LOCK TABLE realtime.schema_migrations IN ACCESS SHARE MODE

Hello <@727539705880772630>!
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.

Its probably easier to just elevate your `postgres` user to a superuser when doing pg_dump and then de-elevate it after you are done.
- elevate
```sql
ALTER USER postgres WITH SUPERUSER;
```
de-elevate
```sql
ALTER USER postgres WITH NOSUPERUSER;
```