Homogeneous replication
The following section describes how Replicate handles replication from Google Cloud AlloyDB for PostgreSQL to the following targets: PostgreSQL, Microsoft Azure Database for PostgreSQL, Google Cloud SQL for PostgreSQL, and Google Cloud AlloyDB for PostgreSQL.
In homogeneous replication, source column and table collations will be replicated to the target as described in Column and table collation.
In homogeneous replication, the source data first passes through the Qlik Replicate data type and is therefore subject to any limitations of that type.
For information on Replicate data types and their limitations (where relevant), see Replicate data types.
For information on which Replicate data types the source data passes through when replicating from Google Cloud AlloyDB for PostgreSQL, see Supported data types.
Limitations and considerations
Homogeneous replication is not supported with the following Replicate configurations or operations:
- Apply Changes only tasks
- Stopping and resuming a task
- Starting a task from a timestamp
- When the If target table already exists in the task settings' Full Load Settings tab is set to Do nothing
Data type considerations and exceptions
When replicating from Google Cloud AlloyDB for PostgreSQL to a PostgreSQL-based target, source and target data types will be identical for all supported PostgreSQL versions, with the following exceptions:
See also the note about JSON data type replication in Supported data types.
Column and table collation
When replicating from Google Cloud AlloyDB for PostgreSQL to a PostgreSQL-based target, column and table collations will be replicated to the target.
To support collation replication, the DBA must ensure that the collations defined for the Google Cloud AlloyDB for PostgreSQL source database are the same as those defined for the PostgreSQL-based target database.
Non-nullable columns and primary/unique index names
Non-nullable columns and Primary/Unique Index names are preserved during homogeneous replication.
Replication of Partitioned Tables
In order to replicate partitioned tables from Google Cloud AlloyDB for PostgreSQL to a PostgreSQL-based target, you need to do the following:
- Manually create the parent and child tables in the target database.
- Define a separate task to replicate to those tables.
- Set the Truncate before loading option in the Full Load Settings.