B.1. Postgres ProGate 1.4.0 #

Release date: 2026-08-17

This release provides features, optimizations, and bug fixes.

B.1.1. New Features and Changes by Components #

B.1.1.1. procopy #

  • Added the sub_tasks_count configuration parameter to procopy_options and task-level parameters to manage the level of parallelization, that is, the number of subtasks an initial task can be split into. The sub_task_rows parameter is announced to be deprecated.

  • Added the force_restart_task configuration parameter to procopy_options and task-level parameters. It allows you to rerun tasks without changing their id values or truncating data.

  • Upgraded the thrift library to version 0.23.0 to fix vulnerabilities found in the previous version.

  • Added support for Postgres Pro AXE for data loading to an S3 storage as the data destination.

  • Added the procopy_options.disable_constraint_checks configuration parameter, which turns off checking of constraints and user triggers when a batch is written to the Postgres Pro/PostgreSQL destination database.

  • Improved logging in case procopy is stopped at the user request with a possibility of filtering service messages that hinder the log analysis.

B.1.1.2. prosync #

  • Added the prosync_options.disable_constraint_checks configuration parameter, which turns off checking of constraints and user triggers when a batch is written to the Postgres Pro/PostgreSQL destination database.

  • Improved logging in case prosync is stopped at the user request with a possibility of filtering service messages that hinder the log analysis.

  • Added the tasks.table.single_loader configuration parameter to allow transferring operations on the table with a single loader if prosync_options.loaders > 1. This ensures sequential processing of changes for tables that have foreign keys or other dependencies.

  • Fixed an issue that prevented prosync reading of records with large SCN values from online logs.

  • Fixed retention of WAL files for Postgres Pro/PostgreSQL sources with rare changes in task tables by improving the advancement techniques for logical replication slots.

  • Increased the performance for application of changes (INSERT/UPDATE) for Oracle.

B.1.1.3. procheck #

  • Added support for Oracle 11.

  • Added filtering of service messages that hinder the log analysis.

  • Upgraded the thrift library to version 0.23.0 to fix vulnerabilities found in the previous version.

B.1.1.4. Postgres ProGate backend #

  • Fixed the error code 404 (Not found) that the API returned instead of 500 (Internal server error) when an attempt to access a non-existing process was made.

  • Added a security event that captures user blocking upon exceeding the number of maximum allowed failed attempts to enter the password, specified by password_policy.max_failed_attempts configuration parameter.

  • Revised data schema introspection by implementing asynchronous processing to significantly improve performance on schemas with a large number of tables.

  • Added support by the API and backend for introspection of access privileges for data schemas and tables.

  • Implemented checking of the source connection consistency for transfers with prosync, as well as of the required privileges for reading tables during the agent operation. The results of checking are available through the API.

  • Implemented and added API support for automated schema and table name matching in data transfer tasks.

B.1.1.5. Postgres ProGate frontend #

  • Changed the behavior of the Create and Save buttons. Previously, they were disabled in case of an empty form or lack of changes. Now the user gets an error message when attempting to click them.

  • Added highlighting of validation errors that occur in an attempt to send the form. If more than three errors are detected, a notification is additionally displayed.

  • Changed the behavior of the Create button during editing. Now if no changes occur, the web page closes without executing the query.

  • Unified the behavior of web pages for users, access groups, projects, and connections, as well as the login page, steps of the wizard for creating data transfer tasks, and key-value fields.

  • Improved the validation and behavior of the web page for creating and editing connections.

  • Made object matching and task saving available only after the successful completion of the introspection.

  • Added a possibility to manage the introspection process: run, restart, and stop.

  • Added the source/target database introspection status to the web interface for replication task creation and editing (the Schema-schema and SQL query task types).

  • Improved the layout of the object matching table by fixing the display of check boxes, chevrons, and data schemas.

  • Added support for the Insufficient rights (insufficient rights for introspection) and Unchecked statuses when creating and updating connections, output of status details and status tooltips for connections, and translation of the undetermined status for processes that completed losing exit codes.

  • Fixed an issue that could cause clicking the Save button after changing user data to fail. A similar logic is fixed on the database connections page.