A.1. Postgres ProGate 1.2.0 #

Release date: 2026-04-30

This release implements security features corresponding to the trust level 4 that are needed for web applications running in state information systems and information systems for personal data. It also extends the functionality of the web application and supported databases, and contains bug fixes.

A.1.1. Main Changes #

Main features added to Postgres ProGate are as follows:

  • Implemented security features of all the components.

  • Added the Postgres ProGate administrator interface.

  • Added a possibility to manage projects that include data transfers and connections.

  • Implemented support of the Content Security Policy.

  • Added procopy support for PostgreSQL 9.

  • Added base support of reading changes from Shardman.

  • Added support for replication of changes to the Oracle destination.

  • Removed the dependency of the procheck verification of data transfer correctness on the Oracle client.

  • Implemented audit features for operations that the user performs in console applications. The applications collect events related to changes in the state of performing data migration and replication tasks.

A.1.2. Other Changes, by Postgres ProGate Components #

A.1.2.1. procopy #

  • Upgraded Go to version 1.26.2.

  • Added logging of the application version, configuration, and launch flags at the procopy start.

A.1.2.2. prosync #

  • Renamed the storage configuration parameter that describes connection to the DB to be used to store the transaction cache. The new name is tx_storage.

  • Added the --allow-shardman-local-tables flag to allow reading Shardman local tables, which is prohibited by default.

  • Added the --allow-partial-shardman-read flag to allow working with partially defined Shardman cluster, which is prohibited by default.

  • Updated the output format for replication statistics, added statistics for cluster shards.

  • Added a possibility to filter DELETE, TRUNCATE and UPDATE operations.

  • Extended the application logging.

  • Added logging of the application version, configuration, and launch flags at the prosync start.

A.1.2.3. procheck #

  • Added the keep_trailing_spaces configuration parameter to define whether to take into account trailing spaces when comparing string types.

  • Added the default_timezone configuration parameter to define the time zone for the values of the timestamp without time zone type.

  • Set the default driver for connection to Oracle to the free go-ora.

  • Removed support of files in the Parquet format from the base package. In case of emergency, you can request the procheck version with this support enabled through the technical support portal.

  • Implemented support of the pg_pathman extension.

  • Added logging of the application version, configuration, and launch flags at the procheck start.

A.1.2.4. Postgres ProGate backend #

  • Added support for administrator operation.

  • Added support for multiuser Postgres ProGate operation.

A.1.2.5. Postgres ProGate frontend #

  • Implemented the user interface for management of users, roles, and access groups.

  • Implemented the user interface for audit of user operations.

  • Implemented user notifications of meaningful events.

  • Implemented support for running the web application in the protected operation environment.

  • Upgraded the SQL editor.

  • Extended the user interface login window, added support for access groups, implemented the interface for user password management.

  • Implemented support for displaying information in the table mapping window for schemas with a large number of tables and columns.

  • Extended support for error notifications.

  • Upgraded the libraries used.