++ed by:
PINGAN

1 PAUSE user
1 non-PAUSE user.

Author image Christopher Jones

NAME

DBIx::Compare::Pg - Compare PostgreSQL database content

SYNOPSIS

        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);   

DESCRIPTION

DBIx::Compare::Pg takes two PostgreSQL database handles and performs comparisons of their table content. See DBIx::Compare for more information.

PORTING NOTES

deep_compare, deep_compare(@aTables)

Use is made of CURSORs to avoid triggering an OOM condition due to libpq's buffering behaviour when comparing tables larger than physical memory.

get_tables

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.

SEE ALSO

DBIx::Compare

AUTHOR

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 AND LICENSE

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.