Remix.run Logo
PostgreSQL Maintenance Without Superuser(boringsql.com)
80 points by radimm 7 days ago | 5 comments
thewisenerd 3 days ago | parent | next [-]

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.

yencabulator 3 days ago | parent | next [-]

Most "managed" Postgres' are like that.

https://neon.com/docs/manage/roles

radimm 3 days ago | parent | prev [-]

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.

SlightlyLeftPad 3 days ago | parent [-]

Correct

paulryanrogers 4 days ago | parent | prev [-]

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