1. Images & Charts
  2. pg-timetable
pg-timetable

pg-timetable

Data
Updated 10 hours ago

pg_timetable Overview

Secure your stack with a hardened pg_timetable image freshly-built by Minimus. Minimus images always include the most up-to-date package version for all packages and dependencies contained in the image.


pg_timetable is an advanced, standalone job scheduler for PostgreSQL. It runs SQL scripts, shell commands, and built-in tasks on cron-style or interval schedules, chaining multiple steps together with automatic retries and dependency handling — all defined and tracked directly in the database it schedules against.


Try It Out

For a quick test, print the version information:

docker run --rm reg.mini.dev/pg-timetable --version

Create a Docker Compose File

To try pg_timetable against a real PostgreSQL database, save the following to a compose.yaml file in your working directory:

services:
  postgres:
    image: reg.mini.dev/postgres:latest
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: postgres
      POSTGRES_DB: timetable
    ports:
      - "5432:5432"
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U postgres"]
      interval: 5s
      timeout: 5s
      retries: 5

  pg-timetable:
    image: reg.mini.dev/pg-timetable:latest
    depends_on:
      postgres:
        condition: service_healthy
    environment:
      PGTT_CONNSTR: "host=postgres port=5432 dbname=timetable user=postgres password=postgres sslmode=disable"
      PGTT_RESTPORT: "8008"
    ports:
      - "8008:8008"
    command:
      - --clientname=demo_worker
      - --upgrade

Start the Services

docker compose up -d

Wait for all services to become healthy:

docker compose ps

Verify the Scheduler Initialized

pg_timetable creates its own timetable schema in the target database on startup. Confirm it exists:

docker compose exec postgres psql -U postgres -d timetable -c "\dn"

A successful initialization lists the timetable schema alongside public:

   List of schemas
   Name    |       Owner
-----------+--------------------
 public    | pg_database_owner
 timetable | postgres
(2 rows)

Clean Up

Stop and remove all containers and volumes:

docker compose down -v

Technical Considerations

The pg_timetable image provided by Minimus is a slim, security-hardened alternative to the public image from Docker Hub. The images are largely interchangeable, with a few differences as noted below.

pg_timetable built by Minimus:

  1. Runs as non-root by default for a security-first approach that protects against privilege escalation attacks.
  2. Drill down on the version specification tab to see the default user, listening ports, entrypoint, volumes, environment variables, etc.

The Payoff

A hardened, minimal image that will remain more secure for the long run and accrue vulnerabilities at a slower rate.


Terms & Info

Trademark

This catalog is published by Minimus. All product names, logos, and marks, other than those belonging to Minimus, shown are owned by their respective rights holders and appear here only to identify the open source software each image contains. Minimus claims no ownership of those marks and implies no affiliation with, endorsement by, certification by, or sponsorship by any rights holder.

Disclaimer

Images are provided "as-is" without warranty of any kind. "Hardened" refers to the security configuration applied at the time of build and does not constitute a guarantee of ongoing security or absence of vulnerabilities. The free tier is provided without support, SLA, or guaranteed patching timelines. Security updates may be applied to paid subscriptions before or instead of free tier images. By pulling or using any image you agree to our Terms of Use.