Skip to content

denvaar/pgdiff

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 

Repository files navigation

pgdiff

Compare what data changed in your Postgres database between two points in time.

It works by just dumping out the tables into files in /var/tmp/pgdiff, so if you have a really large database, then you might have a bad time.

Usage

Start/end a capture (use the same key a second time)

$ pgdiff postgresql://user:password@host:port/db_name -k some_key

Delete existing captures

# all
$ pgdiff postgresql://user:password@host:port/db_name -d

# some_key only
$ pgdiff postgresql://user:password@host:port/db_name -d -k some_key

Limit capture to certain tables only

# no need to use -t on the second time
$ pgdiff postgresql://user:password@host:port/db_name -k some_key -t "table_a,table_b,other table"

Show help info

$ pgdiff -h

About

Compare what data changed between two points in time

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages