PostgreSQL Maintenance Without Superuser

boringsql.com

80 pointsradimm5 comments

sidenote: Azure's PostgreSQL doesn't provide you with superuser, and afaict, you cannot assign pg_read_all_data / pg_write_all_data without it.

this is same with GCP Cloud SQL and RDS (there I need to double check). They really don't want you to access the underlying FS.

Correct

Most "managed" Postgres' are like that.

Nice. Funny how many ways there are to make Postgres sessions/connections effectively read only.