`supabase db push` ERROR: must be owner of table pages (SQLSTATE 42501); while executing migration

[probablykasper]

Bug report

Describe the bug

I'm getting this output when I run supabase db push:

Applying unapplied migrations...
Error: ERROR: must be owner of table pages (SQLSTATE 42501); while executing migration 20220623061201

To Reproduce

I'm just running supabase db push, not sure what exactly causes the error. This was also reported (with a workaround) in discussion https://github.com/supabase/supabase/discussions/6326

System information

• OS: macOS 10.15
• Version of supabase-js: [e.g. 6.0.2]
• Version of Node.js: [e.g. 10.10.0]

Edit: Opened in the wrong repo, would be great if someone could move it to supabase/cli