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

  • FilterandRow 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 and 13	Data and/or Output
EDB PostgreSQL Extended	9.6, 10, 11, 12 and 13	Data and/or Output
EDB PostgreSQL Advanced (EPAS)	11, 12 and 13	Data and/or Output
pglogical	2 and 3	Initial and/or Data
BDR	1, 2 and 3	Initial and/or Data
Oracle	10g, 11g, 12c and 18c	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.