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 14 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 are using pg_upgrade
to upgrade your installation, you should:
- Perform the upgrade.
- 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.