Stouts.docker-postgres
Ansible role to run Postgres with Docker
Variables
postgres_enabled: yes
postgres_prefix: /opt/postgres # Host data directory
postgres_image: postgres:alpine # Docker Postgres Image
postgres_env: {} # ENV variables
postgres_ports: ["5432:5432"] # Listen ports
postgres_volumes: # Container volumes
- "{{postgres_prefix}}/data:/var/lib/postgresql/data"
- "{{postgres_prefix}}/init:/docker-entrypoint-initdb.d:ro"
- "{{postgres_prefix}}/postgres.conf:/etc/postgresql/postgresql.conf"
# Configure postgres (https://www.postgresql.org/docs/current/static/runtime-config.html)
# postgres_options:
# max_connections: "1000"
# shared_buffers: "512MB"
postgres_options: {}
# Init databases, roles
# postgresql_databases:
# - name: "db1"
# - name: "db2"
# postgres_users:
# - { name: "user1", pass: "pass1" }
# - { name: "user2", pass: "pass2" }
# postgres_user_privileges:
# - { name: "user1", db: "db1", priv: "ALL" }
# - { name: "user2", db: "db2", priv: "ALL" }
postgres_databases: []
postgres_users: []
postgres_user_privileges: []Usage
Add Stouts.docker-postgres to your roles and set vars in your playbook file.
Example:
- hosts: all
roles:
- Stouts.docker-postgres
vars:
postgres_databases:
- name: db1
postgres_users:
- name: user1
pass: pass
postgres_user_privileges:
- { name: "user1", db: "db1", priv: "ALL" }
postgres_options:
max_connections: "1000"
max_wal_size: "2GB"
min_wal_size: "1GB"
random_page_cost: "1.1"
shared_buffers: "512MB"License
Licensed under the MIT License. See the LICENSE file for details.
Feedback, bug-reports, requests, ...
Are welcome!