pghoard vs Pg_timetable: What are the differences?
Developers describe pghoard as "Tools for making PostgreSQL backups to cloud object storages". pghoard is a PostgreSQL backup daemon and restore tooling for cloud object storages. On the other hand, Pg_timetable is detailed as "PostgreSQL Job Scheduling". It is an advanced job scheduler for PostgreSQL, offering many advantages over traditional schedulers such as cron and others. It is completely database driven and provides a couple of advanced concepts.
pghoard and Pg_timetable can be categorized as "Database" tools.
Some of the features offered by pghoard are:
- Automatic periodic basebackups
- Automatic transaction log (WAL/xlog) backups (using either pgreceivexlog or archivecommand)
- Cloud object storage support (AWS S3, Google Cloud, OpenStack Swift, Azure, Ceph)
On the other hand, Pg_timetable provides the following key features:
- Tasks can be arranged in chains
- A chain can consist of SQL and executables
- Parameters can be passed to chains
pghoard is an open source tool with 947 GitHub stars and 71 GitHub forks. Here's a link to pghoard's open source repository on GitHub.