Index

PgQuartz is a framework for scheduling PostgreSQL workload across PostgreSQL clusters with an etcd consensus mechanism. PgQuartz jobs can be defined in yaml format as a series of steps consisting of a series of commands and the checks to verify results.

Contents:

• 1. Introduction
• 2. Scheduling
  • 2.1. Systemd/Timer
  • 2.2. Cron
  • 2.3. Kubernetes cron
• 3. PgQuartz jobs
  • 3.1. Graphical representation
  • 3.2. Generic job config chapters
  • 3.3. Example config
• 4. Steps
  • 4.1. Some facts about Steps
  • 4.2. Configuration options
  • 4.3. Example
  • 4.4. Graphical representation
• 5. When
  • 5.1. Some facts about the when statement
  • 5.2. Special methods
  • 5.3. Example
  • 5.4. Graphical representation
• 6. Matrix and job instances
  • 6.1. Passing arguments
  • 6.2. Example config
• 7. Commands
  • 7.1. Limit your output
  • 7.2. Configuration options
  • 7.3. Example
• 8. Checks
  • 8.1. Why this distinction
  • 8.2. Configuration options
  • 8.3. How and when are Checks run
  • 8.4. Example
  • 8.5. Graphical representation
• 9. PgQuartz Connection endpoint configuration
  • 9.1. Configuration options
  • 9.2. Example
• 10. Etcd integration
  • 10.1. Configuration options
  • 10.2. Example