News Score: Score the News, Sort the News, Rewrite the Headlines

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

© News Score  score the news, sort the news, rewrite the headlines