Requirements v1

Suggest edits

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/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:
    - 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/