PostgresSQL 12 CIS

Configure PostgreSQL 12 machine to be CIS compliant

Based on CIS PostgreSQL 12 Benchmark v1.0.0 - November 19, 2019

Caution(s)

This role will make changes to the system which may have unintended concequences. This is not an auditing tool but rather a remediation tool to be used after an audit has been conducted.

This role was developed against a clean install of the Operating System and PosgreSQL 12 database engine. If you are implimenting to an existing system please review this role for any site specific changes that are needed.

To use release version please point to main branch

Documentation

Getting Started
Customizing Roles
Per-Host Configuration
Getting the Most Out of the Role
Wiki
Repo GitHub Page

Requirements

General:

• Basic knowledge of Ansible, below are some links to the Ansible documentation to help get started if you are unfamiliar with Ansible
  • Main Ansible documentation page
  • Ansible Getting Started
  • Tower User Guide
  • Ansible Community Info
• Functioning Ansible and/or Tower Installed, configured, and running. This includes all of the base Ansible/Tower configurations, needed packages installed, and infrastructure setup.
• Please read through the tasks in this role to gain an understanding of what each control is doing. Some of the tasks are disruptive and can have unintended consiquences in a live production system. Also familiarize yourself with the variables in the defaults/main.yml file or the Main Variables Wiki Page.

Technical Dependencies:

• Running Ansible/Tower setup (this role is tested against Ansible version 2.9.1 and newer)
• Python3 Ansible run environment

Role Variables

This role is designed that the end user should not have to edit the tasks themselves. All customizing should be done via the defaults/main.yml file or with extra vars within the project, job, workflow, etc. These variables can be found here in the Main Variables Wiki page. All variables are listed there along with descriptions.

Branches

devel - This is the default branch and the working development branch. Community pull requests will pull into this branch
main - This is the release branch
reports - This is a protected branch for our scoring reports, no code should ever go here
all other branches - Individual community member branches

Community Contribution

We encourage you (the community) to contribute to this role. Please read the rules below.

• Your work is done in your own individual branch. Make sure to Signed-off and GPG sign all commits you intend to merge.
• All community Pull Requests are pulled into the devel branch
• Pull Requests into devel will confirm your commits have a GPG signature, Signed-off, and a functional test before being approved
• Once your changes are merged and a more detailed review is complete, an authorized member will merge your changes into the main branch for a new release