Using PgBouncer with Django and Docker Compose

docker-compose.yml

version: '3'

services:
  app:
    build: .
    image: app
    depends_on:
      - db
    environment:
      - DATABASE_URL=postgresql://db:db@pgbouncer/db
      - DATABASE_NAME=db
    ports:
      - "8000:8000"
    command: bin/wait-for-deps.sh python manage.py runserver 0.0.0.0:8000

  db:
    build:
      context: docker/db
    image: postgres-9.6-postgis-2.3
    environment:
      - POSTGRES_USER=db
      - POSTGRES_PASSWORD=db
      - POSTGRES_DB=db
  
  pgbouncer:
    image: edoburu/pgbouncer
    environment:
       - DB_USER=db
       - DB_PASSWORD=db
       - DB_HOST=db
       - DB_NAME=db
       - POOL_MODE=transaction
       - ADMIN_USERS=postgres,dbuser
    ports:
      - "5432:5432"
    depends_on:
      - db