in reply to Re: Verifying 2 databases are in sync with brute force
in thread Verifying 2 databases are in sync with brute force

I didn't even consider comparing the dumps - I just took it for granted the files would be different due to dated comments or non-deterministic output. But I'll give it a try!

pg-comparator looks interesting. Thanks!

  • Comment on Re^2: Verifying 2 databases are in sync with brute force

Replies are listed 'Best First'.
Re^3: Verifying 2 databases are in sync with brute force
by moritz (Cardinal) on Jun 01, 2011 at 06:29 UTC
    I just dumped the same DB twice in a row (with pg_dump --clean -h localhost -U <user> <dbname>) and both files are identical, no timestamp information and nothing indeterministic in this particular DB.