Platform requirements
LiveCompare requires either:
- an x86 platform with Debian 12 or 13; Ubuntu 22.04 or 24.04; SLES 15 SP7; RHEL 8, 9, or 10; or CentOS/RockyLinux/AlmaLinux 8 or 9
- an ARM64 platform with RHEL 9 or 10, or Debian 13.
Note
Starting with LiveCompare 3.0, ppc64le packages are no longer provided. If you need ppc64le support, use LiveCompare 2.5.1 or earlier.
If your system has internet access, then installing the LiveCompare package using your package manager installs EDB Python (package name edb-python312) as a dependency.
On CentOS/RHEL distributions, LiveCompare also requires the EPEL repository. For details, see the EPEL webpage.
Database requirements
LiveCompare supports the following databases:
- 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)
Note
Oracle 11g requires thick mode with Oracle Instant Client 19 (oracle_thick_mode = on) and comparison_algorithm = full_row. Thick mode is also required for any Oracle version when you compare NCHAR, NVARCHAR2, or NCLOB columns and the database's NLS_NCHAR_CHARACTERSET isn't AL16UTF16. For details, see Oracle support.
LiveCompare only supports the use of LiveCompare with older versions of Postgres (PostgreSQL, EDB Postgres Extended, or EDB Postgres Advanced Server) that have reached end of life in support of performing a major version upgrade to a newer supported version of Postgres.
Note
EDB no longer tests LiveCompare with Oracle 10g. As such, it's no longer on the list of Oracle versions officially supported with LiveCompare. Oracle 10g was previously supported and is expected to continue to work in most cases. However, some limitations may exist.
Installation
You can install LiveCompare from the EnterpriseDB's Repos 2.0 repository. For details, see the LiveCompare installation guide.
LiveCompare with TPAexec
You can use the following sample config for TPA (Trusted Postgres Architect) to build a server with LiveCompare and PostgreSQL 13:
--- architecture: M1 cluster_name: livecompare_m1 cluster_tags: {} cluster_vars: postgres_coredump_filter: '0xff' postgres_version: '13' postgresql_flavour: postgresql repmgr_failover: manual edb_repositories: - enterprise 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 TPA documentation.