PG_COMPARATOR

PG comparator is a perl script that compares tables between two databases instances, generates a diff and applies it on the destination table.

Example use

./pg_comparator --checksum-function=md5 -S -D “pgsql://UUUUUUU:XXXXXXXX@10.1.200.2/DBNAME/TABLENAME?id” pgsql://uuuuuuu:xxxxxx@testdb.1234.eu-central-1.rds.amazonaws.com:5432/testdb

Name		Name	Last commit message	Last commit date
Latest commit History 4 Commits
INSTALL		INSTALL
LICENSE		LICENSE
Makefile		Makefile
README.md		README.md
README.pg_comparator		README.pg_comparator
README.pgc_casts		README.pgc_casts
README.pgc_checksum		README.pgc_checksum
README.xor_aggregate		README.xor_aggregate
casts_test.sql		casts_test.sql
jenkins.c		jenkins.c
mysql_casts.c		mysql_casts.c
mysql_casts.sql		mysql_casts.sql
mysql_checksum.c		mysql_checksum.c
mysql_checksum.sql		mysql_checksum.sql
pg_comparator		pg_comparator
pgc_casts.c		pgc_casts.c
pgc_casts.sql.in		pgc_casts.sql.in
pgc_checksum.c		pgc_checksum.c
pgc_checksum.sql.in		pgc_checksum.sql.in
sqlite_checksum.c		sqlite_checksum.c
sqlite_checksum.sql		sqlite_checksum.sql
xor_aggregate.sql		xor_aggregate.sql