Guide: Security best practices for PostgreSQL
Download for free now!
This free guide presents a framework and a series of recommendations to secure and protect a Postgres database. 
Techniques for securing and minimising access to sensitive data in Postgres require careful planning and design, but can significantly improve the overall security of your data. Postgres offers a rich set of tools to secure the database and control access to the data.
The guide also covers how determining user authentication mechanisms to authenticate different connection attempts is critical to securing your Postgres deployment. Roles are an important part of security in Postgres, and by configuring and securing them properly, we can use them to minimise the risk to your database servers using the principle of least privilege.
The document also explores how encryption plays a big role in the overall security posture of your Postgres deployments and encompasses several different levels of encryption options, such as Transparent Data Encryption, File System Encryption and Full Disk Encryption, to name a few – and the benefits they bring.
And altthough each deployment scenario is unique, this guide is very helpful for reviewing the overall security of your deployments.
The “Security best practices for PostgreSQL” guide is brought to you by EnterpriseDB
Interesting read