Event Planner in PostgreSQL?

Question

Is there a similar event scheduler from MySQL available in PostgreSQL?

Answer 1

While many people just use cron, the closest to the built-in scheduler is PgAgent. This is the component for the pgAdmin GUI Management Tool. A good introduction to it can be found in Configuring PgAgent and Performing Scheduled Backups .

Answer 2

pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database as an extension. The initial employee of the teams in accordance with their schedule, connecting to the local one as the user who planned the work.

pg_cron can run multiple jobs in parallel, but it runs at most one job instance at a time. If it is intended to start the second launch before the first one is completed, the second start will be queued and as soon as the first start is completed. This ensures that tasks are completed exactly as many times as planned and do not start simultaneously with themselves.

If you configured pg_cron in hot standby, then it will start to run cron, which are stored in the table and thus are replicated to hot in standby as soon as the server is moving. This means that you periodically complete tasks automatically with your PostgreSQL server.

Source: citusdata.com