1version: '3.8' 2 3services: 4 postgres: 5 image: postgres:16-alpine 6 container_name: plc-mirror-db 7 restart: unless-stopped 8 network_mode: host 9 environment: 10 POSTGRES_DB: plc_mirror 11 POSTGRES_USER: plc_user 12 POSTGRES_PASSWORD: plc_password 13 ports: 14 - "5432:5432" 15 volumes: 16 - postgres_data:/var/lib/postgresql/data 17 healthcheck: 18 test: ["CMD-SHELL", "pg_isready -U plc_user -d plc_mirror"] 19 interval: 10s 20 timeout: 5s 21 retries: 5 22 command: [ 23 "postgres", 24 "-c", "log_statement=all", 25 "-c", "log_duration=on", 26 "-c", "log_min_duration_statement=0", 27 "-c", "max_connections=200", 28 "-c", "shared_preload_libraries=pg_stat_statements" 29 ] 30 31volumes: 32 postgres_data: 33 driver: local