Requirements v2

LiveCompare requires:

  • Python 3.6 or 3.7
  • PostgreSQL / EDB Postgres Extended 9.5+ / EPAS 11+ (on the output connection)
  • PostgreSQL / EDB Postgres Extended 9.4+ / EPAS 11+ or Oracle 11g+ (on the data connections being compared)

LiveCompare requires Debian 10+, Ubuntu 16.04+, SLES 12 SP5 and 15 SP3, or CentOS/RHEL/RockyLinux/AlmaLinux 7+.

LiveCompare can be installed from the EnterpriseDB products/livecompare repository. More details can be found in:

LiveCompare installs on top of:

  • The latest Python version for Ubuntu, Debian and CentOS/RHEL 8, as provided by the python3 packages; or
  • Python 3.6 for CentOS/RHEL 7, as provided by the python-36 packages.

On CentOS/RHEL distributions, LiveCompare also requires the EPEL repository. More details can be found in:

Specifically on CentOS/RHEL version 7, the Python component tqdm is too old (< 4.16.0). It is possible to install the latest tqdm using pip or pip3 for the user that is running LiveCompare:

pip install --user tqdm --upgrade

If running LiveCompare against an Oracle database, Oracle Instant Client must be installed. Refer to Oracle Support Requirements for additional information.

LiveCompare with TPAexec

The following sample config for TPAexec can be used to build a server with LiveCompare and PostgreSQL 11:

architecture: M1
cluster_name: livecompare_m1
cluster_tags: {}

  postgres_coredump_filter: '0xff'
  postgres_version: '13'
  postgresql_flavour: postgresql
  repmgr_failover: manual
  - products/livecompare/release
    - edb-livecompare
  use_volatile_subscriptions: true

- Name: main

  image: tpa/rocky
  platform: docker
    ansible_user: root

- Name: livem1node1
  location: main
  node: 1
  role: primary
    - 5401:5432
- Name: livem1node2
  location: main
  node: 2
  role: replica
  upstream: livem1node1
    - 5402:5432

More details about TPAexec can be found in: