francomile/ansible-role-postgresql

Ansible Role Postgresql

Ansible Postgresql role

Actions of the Role

• Install Postgresql database (Docker)

Common Usage

roles:
  - {
    role: francomile.postgresql,
    postgresql_base_dir: "{{ postgresql_base_dir | default('/opt/postgresql', true) }}",
    postgresql_container_name: "{{ postgresql_container_name | default('postgres'), true }}",
    postgresql_docker_cpu: 2,
    postgresql_docker_image: "postgres:12",
    postgresql_docker_memory: "4GB",
    postgresql_docker_network: "traefik",
    postgresql_db_name: "postgresdb",
    postgresql_db_user: "postgresuser",
    postgresql_db_password: "myPassword",
    postgresql_expose_port: 5432,
    postgresql_autovacuum_work_mem: "128MB",
    postgresql_log_line_prefix: "%m [%p] %q%u@%d(%h) ",
    postgresql_log_min_error_statement: "warning",
    postgresql_log_statement: "ddl",
    postgresql_maintenance_work_mem: "256MB",
    postgresql_shared_buffers: "512MB",
    postgresql_work_mem: "8MB",
    tags: ["postgres"]
  }

Run the playbook

ansible-playbook -i inventory playbook.yaml -t "postgres"