Supported Technologies

LiveCompare is able to connect to and compare data from a list of technologiesincluding PostgreSQL, BDR and Oracle.

In LiveCompare there are 3 kinds of connections:

  • **Initial**  (optional): Used to fetch metadata about pglogical or BDR

    connections. Required if data connections are pglogical or BDR, and if replication_sets or node_name settings are used. Requires logical_replication_mode = pglogical or logical_replication_mode = bdr. It is required to be a pglogical- or BDR-enabled database.

  • **Data** : The actual database connection that the tool will connect to perform

    data comparison. The first connection in the list is used to solve Table     Filter and Row Filter, and is also used in conjunction with the Initial connection to gather information about BDR nodes. If logical_replication_mode = bdr and all_bdr_nodes = on, then LiveCompare will consider all BDR nodes that are part of the same BDR cluster as the Initial     Connection. In this case it is not necessary to define Data connections individually. The fix can be potentially applied in all Data connections, as comparison and consensus decisions work per row.

  • **Output**  (mandatory): Where LiveCompare will create a schema called

    livecompare, some tables and views. This is required to keep progress and reporting data about comparison sessions. It is required to be a PostgreSQL or 2ndQPostgres connection.

Below you can find about versions and details about supported technologies andin which context they can be used in LiveCompare.

Technology

Versions

Connections

PostgreSQL

9.4

Data

PostgreSQL

9.5, 9.6, 10, 11, 12, 13 and 14

Data and/or Output

EDB PostgreSQL Extended

9.6, 10, 11, 12, 13 and 14

Data and/or Output

EDB PostgreSQL Advanced (EPAS)

11, 12, 13 and 14

Data and/or Output

pglogical

2 and 3

Initial and/or Data

BDR

1, 2 and 3

Initial and/or Data

Oracle

11g, 12c, 18c, 19c and 21c

A single Data connection

PgBouncer Support

LiveCompare can be used against nodes through PgBouncer, but only if usingpool_mode=session because LiveCompare uses prepared statements on PostgreSQL,and it would not be possible if pool_mode were either transaction orstatement.