How to build a successful PostgreSQL security framework
Security Best Practices for PostgreSQL
Securing your PostgreSQL database is a multifaceted undertaking that involves evaluating everything from physical security to authentication protocols.
In fact, database security can be similar to the AAA model for computer security—authentication, authorization, and auditing—with some slight tweaks. Read this EnterpriseDB white paper to learn PostgreSQL security best practices as well as how to implement them in your own database.