pg_dbms_errlog v2.4 released

Поиск
Список
Период
Сортировка
Искать

pg_dbms_errlog v2.4 released

От:
HexaCluster via PostgreSQL Announce <announce-noreply@postgresql.org>
Дата:
 

pg_dbms_errlog v2.4 released

Bangkok, Thailand - June 23, 2026

PostgreSQL DBMS_ERRLOG compatibility extension

The pg_dbms_errlog extension provides the infrastructure that enables you to create an error logging table so that DML operations can continue after encountering errors rather than abort and roll back. It requires the use of the pg_statement_rollback extension or to fully manage the SAVEPOINT in the DML script. Logging in the corresponding error table is done using dynamic shared memory for error queuing and a background worker to write the errors queued into the corresponding error log tables. Note that configuration setting max_worker_processes must be high enough to support the extension, as it will launch up to pg_dbms_errlog.max_workers dynamic background workers, plus an additional fixed background worker.

pg_dbms_errlog v2.3 and v2.4 has been released, they are maintenance releases to add compatibility with PostgreSQL 18 and 19 and fix two major bugs.

Complete list of changes and acknowledgments are available here v2.3 - v2.4

Error logging can be done synchronously by registering the error at query level or when the transaction ends using GUC pg_dbms_errlog.synchronous. Logging at transaction is the default and must be preferred to query, it is the mode that can guarantee that only errors on a committed transaction will be logged. When synchronous logging is disabled off error logging is done when the bg_worker wakes up or when function dbms_errlog.publish_queue() is called or that the synchronous level is changed.

Links & Credits

pg_dbms_errlog is an open project under the PostgreSQL license maintained by HexaCluster and created by Gilles Darold 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 :

About pg_dbms_errlog

Documentation at https://github.com/HexaCluster/pg_dbms_errlog#readme

This email was sent to you from HexaCluster. It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message should be sent to HexaCluster.

You were sent this email as a subscriber of the pgsql-announce mailinglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click the personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
FAQ