PostgreSQL maintenance without superuser
How many people/services have superuser access to your PostgreSQL cluster(s)?
Did you ever ask why your software engineers might need it? Or your BI team?
Why those use cases require same privileges as someone who can drop your
databases?
The answer isn't because these operations are inherently dangerous - it's
because PostgreSQL historically offered limited options for operational access
or simply because not enough people are aware of the options. So the common practice
is to either got basic ...
Read more at boringsql.com