Two years later, you still can't be superuser on DigitalOcean Postgres clusters
digitalocean.com
digitalocean.com
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...