Run a few sanity checks on your logical PostgreSQL replica to make sure its the same as the primary.
Project description
pg-replica-checksummer
Requirements
- Python 3
- Postgres development files (required by psycopg2). On Mac OS, use
brew install postgresql
. On Ubuntu, installlibpq-dev
.
Installation
Using virtualenv, pip install -r requirements.txt
Usage
This script requires three arguments:
--primary
, any acceptable Postgres connection string (incl. DSN),--replica
, same as--primary
but for the replica database,--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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for pg_replica_auditor-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6ce716564e668a9c2a809cb8474c760b357ced9b1812402263ff63ea6567050b |
|
MD5 | 3f772a6201e63e54194cbb076ad43ffd |
|
BLAKE2b-256 | 31b727d8989f145323412e7c233147c4251f1e8ebf4dedacb1bb28a849483705 |