DBIx::Compare::Pg - Compare PostgreSQL database content
use DBIx::Compare::Pg; my $oDB_Comparison = db_comparison->new($dbh1,$dbh2); $oDB_Comparison->verbose; $oDB_Comparison->compare; $oDB_Comparison->deep_compare; $oDB_Comparison->deep_compare(@aTable_Names);
DBIx::Compare::Pg takes two PostgreSQL database handles and performs comparisons of their table content. See DBIx::Compare for more information.
Use is made of CURSORs to avoid triggering an OOM condition due to libpq's buffering behaviour when comparing tables larger than physical memory.
All non-system schemata are searched. Some (hopefully) sensible decisions are made concerning skipping possible Slony schemata (beginning with "_"). Likewise the information schema is passed over.
DBIx::Compare
Christopher Jones, Gynaecological Cancer Research Laboratories, UCL EGA Institute for Women's Health, University College London.
c.jones@ucl.ac.uk
This particular module has seen some hacking from;
Mark Kirkwood, Catalyst IT Limited, New Zealand.
mark.kirkwood@gmail.com
Copyright 2008 by Christopher Jones, University College London
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
To install DBIx::Compare, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::Compare
CPAN shell
perl -MCPAN -e shell install DBIx::Compare
For more information on module installation, please visit the detailed CPAN module installation guide.