pg-replica-auditor 0.0.1

Run a few sanity checks on your logical PostgreSQL replica to make sure its the same as the primary.

pg-replica-checksummer

Requirements

1. Python 3
2. Postgres development files (required by psycopg2). On Mac OS, use brew install postgresql. On Ubuntu, install libpq-dev.

Installation

Using virtualenv, pip install -r requirements.txt

Usage

This script requires three arguments:

1. --primary, any acceptable Postgres connection string (incl. DSN),
2. --replica, same as --primary but for the replica database,
3. --table, the table to check.

Optionally, if you want to see which queries it runs, you can set the --debug option.

Example:

$ (venv) python checksummer.py --primary=postgres://primary-db.amazonaws.com:5432/my_db --replica=postgres://replica-db.amazonaws.com:5432/my_db --table=immutable_items