superuser | Postgres.FM 088 | #PostgreSQL #Postgres podcast

[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]

Nikolay and Michael discuss the superuser role in Postgres — what it is, how and when it shouldn’t be used, and whether most cloud providers are right to not give us it (no prizes for guessing).

Here are some links to things they mentioned:

* superuser (docs) https://www.postgresql.org/docs/current/role-attributes.html#id-1.6.9.6.2.1.2.1.1
* Crunchy Data PostgreSQL Security Technical Implementation Guide (STIG) https://www.crunchydata.com/blog/crunchy-data-postgresql-security-technical-implementation-guide-now-available
* Supabase docs (unsupported operations) https://supabase.com/docs/guides/database/postgres/roles-superuser
* Crunchy Data docs https://docs.crunchybridge.com/concepts/users
* RDS docs https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.html
* Cloud SQL docs https://cloud.google.com/sql/docs/postgres/users
* Azure docs https://learn.microsoft.com/en-us/azure/postgresql/single-server/concepts-servers
* Roles, Privileges, and Security (talk by Ryan Booz) https://www.youtube.com/watch?v=mtPM3iZFE04


~~~


What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov https://twitter.com/samokhvalov and @michristofides https://twitter.com/michristofides


~~~


Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
- Michael Christofides, founder of pgMustard https://pgmustard.com/


~~~


This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.