superuser

Nikolay and Michael discuss the superuser role in PostgreSQL — 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 …

databases postgres postgresql sql technology