Requirements

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+, or CentOS/RHEL/RockyLinux/AlmaLinux 7+.

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

https://techsupport.enterprisedb.com/customer_portal/sw/livecompare/

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:

https://fedoraproject.org/wiki/EPEL

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

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: {}

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

More details about TPAexec can be found in:

https://techsupport.enterprisedb.com/customer_portal/sw/tpa/