krautsalad/postgres

docker-postgres

PostgreSQL with memory tuning, optional slow-query logging, and scheduled vacuum jobs.

docker-postgres extends the official https://hub.docker.com/_/postgres. At startup it generates a tuned postgresql.conf from environment variables, runs PostgreSQL under supervisord together with cron, and can schedule full maintenance on every database (vacuumlo and vacuumdb --all --full --analyze --verbose).

Configuration

Docker Compose Example

yml
# docker-compose.yml
services:
  postgres:
    container_name: postgres
    environment:
      LONG_QUERY_TIME: 3
      MEMORY_GB: 2
      POSTGRES_DB: example
      POSTGRES_PASSWORD: VerySecurePassword
      POSTGRES_USER: postgres
      SLOW_QUERY_LOG: 1
      TZ: Europe/Berlin
      VACUUM_ENABLED: 1
      VACUUM_SCHEDULE: 0 1 * * 6
    healthcheck:
      interval: 30s
      retries: 10
      start_period: 10s
      test: ["CMD", "pg_isready", "-d", "example", "-U", "postgres"]
      timeout: 10s
    image: krautsalad/postgres
    ports:
      - "5432:5432"
    restart: unless-stopped
    volumes:
      - ./postgres-config/zz-overrides.conf:/etc/postgresql/conf.d/zz-overrides.conf:ro
      - ./postgres-logs:/var/log/postgresql
      - ./postgres-data:/var/lib/postgresql

Environment Variables

Image-specific

Official

This image supports the upstream variables. Common ones:

See the https://hub.docker.com/_/postgres for the full list.

How it works

At container start, the custom entrypoint reads the tuning variables, substitutes placeholders in postgresql.conf.template, and writes /etc/postgresql/conf.d/zz-overrides-initial.conf. You can optionally override PostgreSQL settings further by mounting a custom config to /etc/postgresql/conf.d/zz-overrides.conf, as in the Docker Compose example above. If VACUUM_ENABLED is on, it installs a cron file at /etc/crontabs/postgres.

Supervisord then starts PostgreSQL (via the official image entrypoint) and crond for scheduled jobs. Database files are stored under /var/lib/postgresql; mount a volume there to persist data.

Source Code

You can find the full source code on https://github.com/krautsalad/docker-postgres.