From: | MigOps via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org> |
---|---|
To: | PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org> |
Subject: | pg_dbms_job v1.1.0 has been released |
Date: | 2021-09-01 13:05:58 |
Message-ID: | 163050155884.699.4607205039237244853@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
August 28, 2021
## PostgreSQL DBMS_JOB compatibility extension
pg_dbms_job is a PostgreSQL extension to create, manage and use Oracle-style
DBMS_JOB scheduled job. The use and behavior is just like with the DBMS_JOB Oracle
package.
pg_dbms_job v1.1.0 has been released, this is a maintenance release to fix some possible wrong behaviors, give control over other ones and improve the documentation.
- Add configuration directive job_queue_processes to control the limit of jobs that can be run at the same time.
- Fix insertion failure in job history table when PQSTATUS returned contains single quote.
- Fix possible case where asynchronous jobs can be executed twice if they are not removed fast enough from the queue.
- Fix regression test to use latest SQL version of the extension.
- Add limitations on pg_dbms_job use and especially about the NOTIFY queue size limits. Thanks to Julien Rouhaud for the report.
- Add missing information on how to stop or reload configuration of the scheduler.
- Add information that unlike with cron-like scheduler, when the scheduler starts it executes all active jobs with a next date in the past.
- Add information that jobs are executed with the role that has submitted the job and with the search path was used at job creation time.
To upgrade installed pg_dbms_job version 1.0.1 execute:
ALTER EXTENSION pg_dbms_job UPDATE;
after installing the new version using: `make && sudo make install`
## Links & Credits
pg_dbms_job is an open project under the PostgreSQL license created by Gilles Darold at [MigOps Inc](https://migops.com/)
as part of the improvement of Ora2Pg. Any contribution to build a better tool is welcome. You can
send your ideas, features requests or patches using the GitHub tools.
**Links :**
* Download: [https://github.com/MigOpsRepos/pg_dbms_job/releases/](https://github.com/MigOpsRepos/pg_dbms_job/releases/)
* Support: use GitHub report tool at [https://github.com/MigOpsRepos/pg_dbms_job/issues](https://github.com/MigOpsRepos/pg_dbms_job/issues)
## About pg_dbms_job
The pg_dbms_job extension is an original work of [MigOps Inc](https://migops.com/), MigOPs is specialized in migration to PostgreSQL and PostgreSQL support. If you need more information please [contact us](https://www.migops.com/contact-us/)
Documentation at [https://github.com/MigOpsRepos/pg_dbms_job#readme](https://github.com/MigOpsRepos/pg_dbms_job#readme)
From | Date | Subject | |
---|---|---|---|
Next Message | Devart via PostgreSQL Announce | 2021-09-01 19:12:21 | dbForge Data Compare for PostgreSQL Enhanced with New Connectivity Opportunities |
Previous Message | Michel Pelletier via PostgreSQL Announce | 2021-09-01 13:05:10 | Install a local, non-root PostgreSQL Server with Python "pip" |