Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

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

by dwhite20899 (Friar)
on May 31, 2011 at 17:26 UTC ( [id://907508]=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://907508]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (3)
As of 2026-01-16 00:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What's your view on AI coding assistants?





    Results (118 votes). Check out past polls.

    Notices?
    hippoepoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.