Isn't this pretty par for the course when it comes to managed databases? Because the database is managed, they restrict super user access so you don't bork it.
Seems to be the case for AWS[1] and GCP[2]. Not sure if they have a workaround when it comes to `pg_restore` but my understanding was that if you wanted super user access to your database, you would need to manage it yourself.
Seems to be the case for AWS[1] and GCP[2]. Not sure if they have a workaround when it comes to `pg_restore` but my understanding was that if you wanted super user access to your database, you would need to manage it yourself.
1: https://serverfault.com/a/661685 2: https://cloud.google.com/sql/docs/postgres/users#superuser_r...