CloudNativePG Recipe 3 - What!?! No superuser access?
Explore the secure defaults of a PostgreSQL cluster in this CloudNativePG
recipe, aligning with the principle of least authority (PoLA). Our commitment
to security and operational simplicity shines through default configurations,
balancing robust protection with user-friendly settings. Advanced users can
customize as needed. The article navigates default intricacies, PostgreSQL
Host-Based Authentication, and the scenarios for enabling superuser access. We
also touch on the careful use of the ALTER SYSTEM
command, emphasizing our
dedication to secure and simple operations.