Homogeneous replication
When replicating from a PostrgreSQL source to a PostrgreSQL target, most of the source and target data types will be identical. The exceptions are listed in the table below.
Additionally, 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 PostgreSQL, see the PostgreSQL to Qlik Replicate data types mapping table described earlier.
Replication of Partitioned Tables
In order to replicate partitioned tables from a PostgreSQL source to a PostgreSQL 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.