Skip to content
Announcing BigAnimal: Fully managed PostgreSQL in the Cloud
Contact usDocsPlans

Video: Applying PostgreSQL Security to the AAA Framework

Marc Linster11/2/2020

When applying PostgreSQL security features to the AAA framework—which stands for Authentication, Authorization, and Auditing—step one is Authentication. This means verifying that the user is who he or she claims to be.

The PostgreSQL host-based access file restricts access based on user name, database, and source IP—if the user is connecting via TCP/IP. Authentication methods are assigned in this file as well. The authentication method or methods you choose depend on your use case.

Methods include Kerberos/GSSAPI, SSPI, LDAP and RADIUS, Cert, md5, Scram, Reject, and Trust. It’s imperative that you have a full understanding of the ramifications of each authentication method.

Watch the video below to learn more!


You can download our whitepaper here to read more about PostgreSQL security best practices.

Marc Linster, Ph.D., is EDB’s Chief Technology Officer. Marc is committed to EDB being an accelerator to providing architectural “know how” to help customers take advantage of Postgres without significant risk and cost. Marc believes that although new customer adoption of open source is easier than ...