voltgres/docker-compose.yml at main · techtegrity/voltgres · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
services:
  voltgres:
    build:
      context: .
      args:
        NEXT_PUBLIC_GOOGLE_ENABLED: ${NEXT_PUBLIC_GOOGLE_ENABLED:-false}
    container_name: voltgres
    restart: unless-stopped
    ports:
      - "${VOLTGRES_PORT:-3000}:3000"
    environment:
      - BETTER_AUTH_SECRET=${BETTER_AUTH_SECRET}
      - BETTER_AUTH_URL=${BETTER_AUTH_URL:-http://localhost:3000}
      - NEXT_PUBLIC_APP_URL=${NEXT_PUBLIC_APP_URL:-http://localhost:3000}
      - VOLTGRES_DB_PATH=/app/data/voltgres.db
      - GOOGLE_CLIENT_ID=${GOOGLE_CLIENT_ID:-}
      - GOOGLE_CLIENT_SECRET=${GOOGLE_CLIENT_SECRET:-}
      - DOMAIN=${DOMAIN:-}
      - NEXT_PUBLIC_GOOGLE_ENABLED=${NEXT_PUBLIC_GOOGLE_ENABLED:-false}
      - POSTGRES_HOST=postgres
      - POSTGRES_PORT=5432
      - POSTGRES_USER=${POSTGRES_USER:-postgres}
      - POSTGRES_PASSWORD=${POSTGRES_PASSWORD:-voltgres}
    volumes:
      - voltgres-data:/app/data
      - /var/run/docker.sock:/var/run/docker.sock
    depends_on:
      postgres:
        condition: service_healthy
    networks:
      - voltgres-net

  postgres:
    image: postgres:16-alpine
    container_name: voltgres-postgres
    restart: unless-stopped
    entrypoint: ["/pg-entrypoint.sh"]
    environment:
      - POSTGRES_USER=${POSTGRES_USER:-postgres}
      - POSTGRES_PASSWORD=${POSTGRES_PASSWORD:-voltgres}
      - POSTGRES_DB=${POSTGRES_DB:-postgres}
      - DOMAIN=${DOMAIN:-}
    ports:
      - "${POSTGRES_PORT:-5432}:5432"
    volumes:
      - postgres-data:/var/lib/postgresql/data
      - postgres-ssl:/var/lib/postgresql/ssl
      - postgres-logs:/var/log/postgresql
      - caddy-data:/caddy-data:ro
      - ./pg-entrypoint.sh:/pg-entrypoint.sh:ro
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U ${POSTGRES_USER:-postgres}"]
      interval: 5s
      timeout: 5s
      retries: 5
    networks:
      - voltgres-net

  fail2ban:
    image: alpine:3.21
    container_name: voltgres-fail2ban
    restart: unless-stopped
    entrypoint: ["/fail2ban-entrypoint.sh"]
    cap_add:
      - NET_ADMIN
      - NET_RAW
    network_mode: host
    environment:
      - FAIL2BAN_POSTGRES_PORTS=${POSTGRES_PORT:-5432}
      - FAIL2BAN_MAXRETRY=${FAIL2BAN_MAXRETRY:-5}
      - FAIL2BAN_BANTIME=${FAIL2BAN_BANTIME:-3600}
      - FAIL2BAN_FINDTIME=${FAIL2BAN_FINDTIME:-600}
    volumes:
      - postgres-logs:/var/log/postgresql:ro
      - fail2ban-data:/var/lib/fail2ban
      - ./fail2ban-entrypoint.sh:/fail2ban-entrypoint.sh:ro
      - ./fail2ban/jail.local:/etc/fail2ban/jail.local:ro
      - ./fail2ban/filter.d/postgresql.conf:/etc/fail2ban/filter.d/postgresql.conf:ro
      - ./fail2ban/action.d/docker-iptables.conf:/etc/fail2ban/action.d/docker-iptables.conf:ro
    depends_on:
      postgres:
        condition: service_healthy

  pgbouncer:
    image: edoburu/pgbouncer:latest
    container_name: voltgres-pgbouncer
    restart: unless-stopped
    user: root
    entrypoint: ["/custom-entrypoint.sh"]
    command: ["pgbouncer", "/etc/pgbouncer/pgbouncer.ini"]
    ports:
      - "${PGBOUNCER_PORT:-6432}:5432"
    volumes:
      - ./pgbouncer-entrypoint.sh:/custom-entrypoint.sh:ro
      - caddy-data:/caddy-data:ro
    environment:
      - DOMAIN=${DOMAIN:-}
      - DATABASE_URL=postgres://${POSTGRES_USER:-postgres}:${POSTGRES_PASSWORD:-voltgres}@postgres:5432
      - AUTH_TYPE=scram-sha-256
      - AUTH_QUERY=SELECT usename, passwd FROM pg_shadow WHERE usename=$1
      - POOL_MODE=transaction
      - DEFAULT_POOL_SIZE=20
      - MIN_POOL_SIZE=0
      - RESERVE_POOL_SIZE=5
      - MAX_CLIENT_CONN=200
      - MAX_DB_CONNECTIONS=50
      - SERVER_IDLE_TIMEOUT=300
      - QUERY_WAIT_TIMEOUT=120
      - ADMIN_USERS=${POSTGRES_USER:-postgres}
      - IGNORE_STARTUP_PARAMETERS=extra_float_digits,search_path,uselibpqcompat
      - CLIENT_TLS_SSLMODE=require
      - CLIENT_TLS_KEY_FILE=/etc/pgbouncer/tls/client.key
      - CLIENT_TLS_CERT_FILE=/etc/pgbouncer/tls/client.crt
    depends_on:
      postgres:
        condition: service_healthy
    networks:
      - voltgres-net

  caddy:
    image: caddy:2-alpine
    container_name: voltgres-caddy
    restart: unless-stopped
    profiles:
      - https
    ports:
      - "80:80"
      - "443:443"
      - "443:443/udp"
    volumes:
      - ./Caddyfile:/etc/caddy/Caddyfile:ro
      - caddy-data:/data
      - caddy-config:/config
    environment:
      - DOMAIN=${DOMAIN}
      - ALLOWED_IPS=${ALLOWED_IPS:-}
    depends_on:
      - voltgres
    networks:
      - voltgres-net

volumes:
  voltgres-data:
  postgres-data:
  postgres-ssl:
  postgres-logs:
  fail2ban-data:
  caddy-data:
  caddy-config:

networks:
  voltgres-net:
    driver: bridge