Requirements v2

LiveCompare requires:

  • Python 3.6 or 3.7
  • PostgreSQL / EDB Postgres Extended 9.5+ / EDB Postgres Advanced Server 11+ (on the output connection)
  • PostgreSQL / EDB Postgres Extended 9.4+ / EDB Postgres Advanced Server 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+.

You can install LiveCompare from the EnterpriseDB products/livecompare repository. For details, see the EDB customer portal.

LiveCompare installs on top of either:

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

On CentOS/RHEL distributions, LiveCompare also requires the EPEL repository. For details, see the EPEL webpage.

Specifically on CentOS/RHEL version 7, the Python component tqdm is too old (< 4.16.0). You can 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. See Oracle support requirements for more information.

LiveCompare with TPAexec

You can use the following sample config for TPAexec to build a server with LiveCompare and PostgreSQL 11:

---
architecture: M1
cluster_name: livecompare_m1
cluster_tags: {}

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

locations:
- Name: main

instance_defaults:
  image: tpa/rocky
  platform: docker
  vars:
    ansible_user: root

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

For details about TPAexec, see the EDB customer portal.