Release date: 2026-02-06
This is the first public release of the Postgres ProGate software, designed for data migration and replication between different source and destination databases, referred to as sources and destinations.
Main features of Postgres ProGate are as follows:
Main data migration and replication features.
Support of Oracle, PostgreSQL, and Postgres Pro DBMS as sources.
Support of PostgreSQL and Postgres Pro DBMS as destinations.
Data export to files in the Apache Parquet format.
Techniques to check the quality of data migration.
Conversion of source data types to destination data types; a possibility to configure strings to be converted to NULL.
A possibility to change EOL characters during data processing.
Redefinition of lists of tables and fields for data migration and replication.
Support for case-insensitive names of database objects.
Configuration of the parallelism of data migration tasks. Specifically, a possibility of multi-threaded transfer of individual tables.
A possibility to use a DB snapshot to get data for the migration.
Support of conditions for data selection.
A possibility to stop data migration or replication process correctly and restore the process from the termination point.
Support of high-availability features offered by Postgres Pro BiHA.
Postgres ProGate includes the following components:
Data migration and replication tasks can be managed through the web interface or by means of the command-line interface.