postgresql

Below are some examples for a postgresql based configuration.

Docker compose microservices

docker-compose.yaml

version: "3.5"
services:
  db:
    image: postgres
    restart: always
    environment:
      - POSTGRES_USER=wrangler
      - PGUSER=wrangler
      - POSTGRES_PASSWORD=change_me
      - POSTGRES_DB=wrangler
    volumes:
      - ./pgsql:/var/lib/pgsql
    healthcheck:
      test: [ "CMD-SHELL", "pg_isready", "-d", "db_prod" ]
      interval: 10s
      timeout: 10s
      retries: 5

  proxy:
    image: noah231515/receipt-wrangler-proxy:latest
    ports:
      - 9082:80
    depends_on:
      - api
      - frontend

  api:
    image: noah231515/receipt-wrangler-api:latest
    restart: always
    command: ./api --env prod
    ports:
      - 9080:8081
    volumes:
      - ./data:/go/api/data
      - ./logs:/go/api/logs
    environment:
      - ENCRYPTION_KEY=encryptionKey
      - SECRET_KEY=secretKey
      - DB_USER=wrangler
      - DB_PASSWORD=changeMe
      - DB_NAME=wrangler
      - DB_HOST=db
      - DB_PORT=5432
      - DB_ENGINE=postgresql
    depends_on:
      db:
        condition: service_healthy

  frontend:
    image: noah231515/receipt-wrangler-desktop:latest
    restart: always
    ports:
      - 9081:80

Docker compose monolithic

docker-compose.yaml

services:
  db:
    image: postgres
    restart: always
    environment:
      - POSTGRES_USER=wrangler
      - POSTGRES_PASSWORD=change_me
      - POSTGRES_DB=wrangler
    volumes:
      - ./pgsql:/var/lib/pgsql
    healthcheck:
      test: [ "CMD-SHELL", "pg_isready", "-d", "db_prod" ]
      interval: 10s
      timeout: 10s
      retries: 5

  wrangler:
    image: noah231515/receipt-wrangler:latest
    entrypoint: ./entrypoint.sh
    restart: always
    volumes:
      - ./data:/app/receipt-wrangler-api/data
      - ./logs:/app/receipt-wrangler-api/logs
    environment:
      - ENCRYPTION_KEY=encryptionKey
      - SECRET_KEY=secretKey
      - DB_USER=wrangler
      - DB_PASSWORD=changeMe
      - DB_NAME=wrangler
      - DB_HOST=db
      - DB_PORT=5432
      - DB_ENGINE=postgresql
    depends_on:
      db:
        condition: service_healthy
    ports:
      - 9082:80