Upgrading a pgAgent installation v15

If your existing EDB Postgres Advanced Server installation uses pgAgent, you can use a script provided with the EDB Postgres Advanced Server installer to update pgAgent. The script is named dbms_job.upgrade.script.sql and is located in the /share/contrib/ directory under your EDB Postgres Advanced Server installation.

If you're using pg_upgrade to upgrade your installation:

  1. Perform the upgrade.
  2. Invoke the dbms_job.upgrade.script.sql script to update the catalog files. If your existing pgAgent installation was performed with a script, the update converts the installation to an extension.