Database

Deprecated

Not deployed

files docker management multimedia cloud

About

To manage our database for various app we use PostgreSQL. With multiple databases on a single instance.

Setup

version: '3.8'
services:
  db:
    image: postgres:15
    hostname: postgres
    restart: unless-stopped
    environment:
      - POSTGRES_DB=${POSTGRES_USER}
      - POSTGRES_USER=${POSTGRES_USER}
      - POSTGRES_PASSWORD=${POSTGRES_PASSWORD}
    ports:
      - 5432:5432
    volumes:
      - /data/docker/postgres/data:/var/lib/postgresql/data/
    networks:
      - homelab
    deploy:
      placement:
        constraints:
          - node.hostname == neptune

networks:
  homelab:
    external: true

Deprecated

I decided to switch back to : 1 instance = 1 database = 1 app, for simplicity.