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/livecomparerepository. 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 pip3for 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 withLiveCompare 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/redhat
 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/