Download pg commander install#

And pg_cron is also included in managed Postgres database services such as the Hyperscale (Citus) and Flexible Server options in Azure Database for PostgreSQL.

Download pg commander install#

You can find the pg_cron extension on GitHub-it’s open source, and it’s easy to install and set up. Since its initial release, pg_cron has become a standard tool in the arsenal for many of you who use PostgreSQL. SELECT cron.schedule('delete-old-events','30 1 * * 6', $$DELETE FROM events WHERE event_time < now() - interval '1 week'$$) Delete old data on Saturday at 1:30am (GMT) SELECT cron.schedule('upgrade-pgcron', 'ALTER EXTENSION pg_cron UPDATE') upgrade an extension when PostgreSQL restarts SELECT cron.schedule('process-new-events', '* * * * *', 'CALL process_new_events()') SELECT cron.schedule('0 3 * * *', 'VACUUM my_table') vacuum my table every night at 3am (GMT) Using pg_cron, you can schedule Postgres queries to run periodically, according to the familiar cron syntax. That is why I created the open source pg_cron extension back in 2016 to run periodic jobs in Postgres-and why I continue to maintain pg_cron now that I work on the Postgres team at Microsoft. As a computing platform, I always felt that Postgres should be able to take actions in an automated way. Postgres is so programmable that I often think of Postgres as a computing platform rather than just a database (or a distributed computing platform- with Citus). One of the unique things about Postgres is that it is highly programmable via PL/pgSQL and extensions.