Installing pg_cron

pg_cron is supported on the same platforms as the Postgres distribution you're using. Support for pg_cron starts with Postgres 10. For details, see:

• EDB Postgres Advanced Server Product Compatibility
• PostgreSQL Product Compatibility
• EDB Postgres Extended Server Product Compatibility

Installation

Before you begin the installation process:

• Install Postgres. See:

  • Installing EDB Postgres Advanced Server

  • Installing PostgreSQL

  • Installing EDB Postgres Extended Server

• Set up the repository.

  Setting up the repository is a one-time task. If you've already set up your repository, you don't need to perform this step.

  To set up the repository, go to EDB repositories and follow the instructions provided there.

Install the package

The syntax for the package install command is:

# For SLES, CentOS, RHEL and its derivatives
sudo <package-manager> -y install edb-<postgres><postgres_version>-pg-cron1

# For Debian and Ubuntu
sudo <package-manager> -y install edb-<postgres><postgres_version>-pg-cron-1

Where:

• <package-manager>is the package manager used with your operating system:

  Package manager	Operating system
  dnf	RHEL 8/9 and derivatives
  yum	RHEL 7 and derivatives, CentOS 7
  zypper	SLES
  apt-get	Debian and derivatives

• <postgres> is the distribution of Postgres you're using:

  Postgres distribution	Value
  PostgreSQL	pg
  EDB Postgres Advanced Server	as
  EDB Postgres Extended Server	postgresextended

• <postgres_version> is the version of Postgres you're using.

For example, to install pg_cron for EDB Postgres Advanced Server 15 on a RHEL 8 platform:

sudo dnf -y install edb-as15-pg-cron1

• On this page
• Installation
• Install the package