---
- name: postgresql-server
  tags:
    - postgresql-server
  block:
    - name: Install PostgreSQL APT key
      tags: pg
      notify: update apt cache
      apt_key:
        id: ACCC4CF8
        keyserver: keyserver.ubuntu.com

    - name: PostgreSQL APT repository
      tags: pg
      notify: update apt cache
      copy:
        dest: /etc/apt/sources.list.d/postgresql.list
        content: 'deb http://apt.postgresql.org/pub/repos/apt/ stretch-pgdg main'

- meta: flush_handlers

- tags:
    - postgresql-server
  block:
    - name: packages
      apt:
        name: "{{ item }}"
        install_recommends: no
      with_items:
        - postgresql-10
        - postgresql-client-10

    - name: Logrotate
      copy:
        dest: /etc/logrotate.d/postgresql-common
        content: |
          # Managed by Ansible
          /var/log/postgresql/*.log {
                 daily
                 dateext
                 copytruncate
                 delaycompress
                 compress
                 notifempty
                 missingok
                 su root root
          }