PostgreSQL Maintenance Without Superuser

80 pointsposted 5 months ago
by radimm
(boringsql.com)

5 Comments

thewisenerd

5 months ago

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.

radimm

5 months ago

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.

paulryanrogers

5 months ago

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