postgresql

Ansible role to install postgresql server in docker environment

This role configure :

• docker network

• docker service

• docker volume

an example of variables file :

---
postgresql_docker_project_directory: "/tmp/postgresql"
postgresql_docker_data_directory: "{{ postgresql_docker_project_directory }}/data"
postgresql_docker_compose_file_path: "{{ postgresql_docker_project_directory }}/docker-compose.yml"

postgresql_docker_network_name: "postgresql"
postgresql_docker_network_subnet: 172.26.0.0/24
postgresql_docker_network_gateway: 172.26.0.1

postgresql_docker_databases: 
  - "db1:user1:passord1"
  - "db42:user42:password42"

postgresql_docker_server_name: "postgresql"
postgresql_docker_image: "codeberg.org/rtnp/postgresql-multi-databases:latest"
postgresql_docker_container_name: "{{ postgresql_docker_server_name }}"
postgresql_docker_network_ipv4_address: "172.26.0.43"
postgresql_docker_port: "5432"

postgresql_docker_username: "admin"
postgresql_docker_password: "admin"

Enjoy :)

Defaults

postgresql_docker_project_directory: "/tmp/postgresql"
postgresql_docker_data_directory: "{{ postgresql_docker_project_directory }}/data"
postgresql_docker_compose_file_path: "{{ postgresql_docker_project_directory }}/docker-compose.yml"

postgresql_docker_network_name: "postgresql"
postgresql_docker_network_subnet: 172.26.0.0/24
postgresql_docker_network_gateway: 172.26.0.1

postgresql_docker_databases:
  - "db1:user1:passord1"
  - "db42:user42:password42"

postgresql_docker_server_name: "postgresql"
postgresql_docker_image: "codeberg.org/rtnp/postgresql-multi-databases:latest"
postgresql_docker_container_name: "{{ postgresql_docker_server_name }}"
postgresql_docker_network_ipv4_address: "172.26.0.43"
postgresql_docker_port: "5432"

postgresql_docker_username: "admin"
postgresql_docker_password: "admin"