RIDING BYTES: PostgreSQL Role

This role provisions PostgreSQL.

This role istalls PostgreSQL using the PostgreSQL Ansible Role and configure it in secure ways.

Dependencies

This role depends on the follwoing Ansible Roles:

• PostgreSQL

PostgreSQL Variables

Please refer to the PostgreSQL Ansible Role for available variables. This role customizes the following variables in vars/main.yml:

postgresql_version: 9.5

Install PostgreSQL version 9.5 per default.

postgresql_pg_hba_default:
  - type: local
    database: all
    user: '{{ postgresql_admin_user }}'
    address: ''
    method: 'peer'
    comment: ''
  - type: local
    database: all
    user: all
    address: ''
    method: 'peer'
    comment: '"local" is for Unix domain socket connections only'

Only allow local connections to the Unix-domain socket uainf peer authentication. Please see PostgreSQL Host Based Authentication Documentation for available settings.