pg_timetable - Advanced PostgreSQL job scheduling Job scheduling is one of the most important topics in modern application and database management.
In the PostgreSQL ecosystems, pgAgent and pg_cron have become quite popular. However, both
tools have a fair amount of limitations.
Hence, we have decided to release our own solution: Welcome pg_timetable, the next generation
PostgreSQL job scheduler.
Advantages of pg_timetable:a.) pg_timetable is a daemon: In contrast to other tools, pg_timetable is not a PostgreSQL worker process. This means that if the
scheduler crashes, it cannot harm your server. pg_timetable is an independent process written in
GO which connects to PostgreSQL just like any other client program.
b.) pg_timetable supports chaining Often you want to execute a sequence of tasks and not just a single operation. Maybe you want to
download a file, import it, run some aggregation, commit the transaction and send an email. All those
base tasks might be used under different circumstances using different set of parameters. Maybe
you want to send emails to notify your clients about something going on in the database, send a
reminder or whatever. pg_timetable provides a variety of built in tasks which help you to flexibly
combine those operations in an easy way. Simply select a base task, pass parameters, and assign
those tasks to an execution chain.
c.) Concurrency protection If you are still using cron jobs, one of the major problems is that a job might run more than once at the
same time. This can lead to serious problems that might harm your database. pg_timetable can handle
concurrency protection for you. You can tell the system that a chain can only be executed once at a
time. In the near future, you will even be able to set an upper limit of concurrent jobs.
d.) Configuring jobs "cron style" Most people know how to use cron. In order to get you started quickly, pg_timetable also supports a
cron-style configuration interface to make it easier to configure jobs as fast as possible. This is especially
useful if you want to run simple jobs.
e.) Statically linked binaries There is no need to worry about libraries or dependencies. pg_timetable has been implemented in GO
and therefore comes as ONE executable which can be started directly. No missing libraries, no Linux
specifics. We also provide a ready to use Dockerfile if you want to directly run pg_timetable in a container.
pg_timetable is Open Source and can be used freely by everyone.
Visit our GitHub page for downloads and details.
https://www.cybertec-postgresql.com/en/products/pg_timetable/https://github.com/cybertec-postgresql/pg_timetable--
Hans-Jürgen Schönig
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt
Web: https://www.cybertec-postgresql.com