Requirements

LiveCompare requires:

  • Python >= 3.6 and <= 3.8

  • PostgreSQL / EDB Postgres Extended 9.5+ / EPAS 11+ (on the output connection)

  • PostgreSQL / EDB Postgres Extended 9.4+ / EPAS 11+ or Oracle 10g+ (on the data connections being compared)

LiveCompare requires at least Debian 10, Ubuntu 16.04, or CentOS/RHEL 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:
   *   - 2ndq-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/