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
storageconfiguration parameter that describes connection to the DB to be used to store the transaction cache. The new name istx_storage.Added the
--allow-shardman-local-tablesflag to allow reading Shardman local tables, which is prohibited by default.Added the
--allow-partial-shardman-readflag 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,TRUNCATEandUPDATEoperations.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_spacesconfiguration parameter to define whether to take into account trailing spaces when comparing string types.Added the
default_timezoneconfiguration parameter to define the time zone for the values of thetimestamp without time zonetype.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.