The permissions granted rds_superuser and cloudsqlsuperuser make it seamless, though. In case of Aiven.io, you are not able to see queries through pg_stat_statements ; insufficient permissions for pg_stat_replication; I couldn’t use pg_terminate_backend when backend belonged to another role; must use https://github.com/aiven/aiven-extras to set up logical replication.

Software architect, startup adviser. Editor of https://medium.com/applaudience. Founder of https://go2cinema.com.

Software architect, startup adviser. Editor of https://medium.com/applaudience. Founder of https://go2cinema.com.