pg_comparator

efficient PostgreSQL table content comparison and synchronization

Install

All systems
curl cmd.cat/pg_comparator.sh
Debian Debian
apt-get install postgresql-comparator
Ubuntu
apt-get install postgresql-comparator
image/svg+xml Kali Linux
apt-get install postgresql-comparator
Windows (WSL2)
sudo apt-get update sudo apt-get install postgresql-comparator
Raspbian
apt-get install postgresql-comparator

postgresql-comparator

efficient PostgreSQL table content comparison and synchronization

This script performs a network and time efficient comparison or synchronization of two possibly large tables on two PostgreSQL database servers, so as to detect inserted, updated or deleted tuples between these tables.