Hello community, here is the log from the commit of package pg_comparator for openSUSE:Factory checked in at 2014-04-30 15:10:13 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/pg_comparator (Old) and /work/SRC/openSUSE:Factory/.pg_comparator.new (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "pg_comparator" Changes: -------- --- /work/SRC/openSUSE:Factory/pg_comparator/pg_comparator.changes 2014-03-06 12:06:21.000000000 +0100 +++ /work/SRC/openSUSE:Factory/.pg_comparator.new/pg_comparator.changes 2014-04-30 15:10:14.000000000 +0200 @@ -1,0 +2,6 @@ +Mon Apr 21 06:46:09 UTC 2014 - [email protected] + +- New Version: 2.2.3 +- Minor Update + +------------------------------------------------------------------- Old: ---- pg_comparator-2.2.2.tgz New: ---- pg_comparator-2.2.3.tgz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ pg_comparator.spec ++++++ --- /var/tmp/diff_new_pack.ovQWIQ/_old 2014-04-30 15:10:16.000000000 +0200 +++ /var/tmp/diff_new_pack.ovQWIQ/_new 2014-04-30 15:10:16.000000000 +0200 @@ -22,14 +22,14 @@ %define pgdocdir %{expand:%%(/usr/bin/pg_config --docdir)} Name: pg_comparator -Version: 2.2.2 +Version: 2.2.3 Release: 1%{?dist} Summary: A tool to compare and sync tables in different locations License: BSD-3-Clause Group: Development/Libraries Url: http://pgfoundry.org/projects/pg-comparator/ -Source: http://pgfoundry.org/frs/download.php/3597/pg_comparator-%{version}.tgz +Source: http://pgfoundry.org/frs/download.php/3643/pg_comparator-%{version}.tgz BuildRoot: %{_tmppath}/%{name}-%{version}-build ++++++ pg_comparator-2.2.2.tgz -> pg_comparator-2.2.3.tgz ++++++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/pg_comparator-2.2.2/pg_comparator new/pg_comparator-2.2.3/pg_comparator --- old/pg_comparator-2.2.2/pg_comparator 2014-01-08 22:24:58.000000000 +0100 +++ new/pg_comparator-2.2.3/pg_comparator 2014-04-19 17:11:43.000000000 +0200 @@ -1,6 +1,6 @@ #!/usr/bin/perl # -# $Id: pg_comparator.pl 1485 2014-01-08 21:24:58Z coelho $ +# $Id: pg_comparator.pl 1494 2014-04-19 15:11:43Z coelho $ # # HELP 1: pg_comparator --man # HELP 2: pod2text pg_comparator @@ -296,6 +296,14 @@ Default is to use temporary tables that are automatically wiped out when the connection is closed. +=item C<--unlogged>, C<--no-unlogged> + +Use unlogged tables for storing checksums. These tables are not transactional, +so it may speed up things a little. However, they are not automatically cleaned +up at the end. See C<--clear> option to request a cleanup. + +Default is not to use unlogged tables. + =item C<--threads> or C<-T>, C<--no-threads> or C<-N> Highly EXPERIMENTAL feature. @@ -857,7 +865,8 @@ If the tables to compare are in the same database, a simple SQL query can extract the differences. Assuming Tables I<T1> and I<T2> with primary key I<id> and non null contents I<data>, then their -differences is summarized by the following query: +differences, that is how I<T1> differs from the reference I<T2>, +is summarized by the following query: SELECT COALESCE(T1.id, T2.id) AS key, CASE WHEN T1.id IS NULL THEN 'DELETE' @@ -1089,6 +1098,13 @@ =over 4 +=item B<version 2.2.3> (r1494 on 2014-04-19) + +Improved documentation. +Add C<--unlogged> option to use unlogged tables. +The I<release> validation was run successfully +on PostgreSQL 9.3.4 and MySQL 5.5.35. + =item B<version 2.2.2> (r1485 on 2014-01-08) Fix some warnings reported by I<Ivan Mincik>. @@ -1344,19 +1360,19 @@ =cut -my $script_version = '2.2.2 (r1485)'; -my $revision = '$Revision: 1485 $'; +my $script_version = '2.2.3 (r1494)'; +my $revision = '$Revision: 1494 $'; $revision =~ tr/0-9//cd; ################################################################# SOME DEFAULTS # various option defaults -my ($verb, $debug, $temp, $ask_pass, $factor, $clear) = (0, 0, 1, 0, 7, 0); +my ($verb, $debug, $temp, $unlog, $ask_pass, $clear) = (0, 0, 1, 0, 0, 0); my ($max_ratio, $max_levels, $report, $threads, $async) = (0.1, 0, 1, 0, 1); my ($cleanup, $size, $usekey, $usenull, $synchronize) = (0, 0, 0, 1, 0); my ($do_it, $do_trans, $prefix, $ckcmp) = (0, 1, 'pgc_cmp', 'create'); my ($maskleft, $name, $key_size, $col_size, $where) = (1, 'none', 0, 0, ''); -my ($expect_warn) = (0); +my ($factor, $expect_warn) = (7, 0); # condition, tests, max size of blobs, data sources... my ($expect, $longreadlen, $source1, $source2, $key_cs, $tup_cs, $do_lock, $env_pass, $max_report, $stats); @@ -1619,8 +1635,9 @@ 'attrs' => {}, # sql-comparison which is null-safe 'safeeq' => ' IS NOT DISTINCT FROM ?', - # sql temporary table + # sql temporary or unlogged table 'temporary' => 'TEMPORARY ', + 'unlogged' => 'UNLOGGED ', # sql drop table 'drop_table' => 'DROP TABLE IF EXISTS', # actual aggregates to use @@ -1692,6 +1709,7 @@ 'attrs' => {}, 'safeeq' => '<=>?', 'temporary' => 'TEMPORARY ', + 'unlogged' => '', # mysql myisam is always unlogged? 'drop_table' => 'DROP TABLE IF EXISTS', 'xor' => 'BIT_XOR', 'sum' => 'SUM', @@ -1741,6 +1759,7 @@ 'attrs' => {}, 'safeeq' => '=?', # ??? 'temporary' => 'TEMPORARY ', + 'unlogged' => 'TEMPORARY ', 'drop_table' => 'DROP TABLE IF EXISTS', 'xor' => 'XOR', 'sum' => 'ISUM',# work around 'SUM' and 'TOTAL' overflow handling @@ -1810,6 +1829,7 @@ 'attrs' => {}, 'safeeq' => ' IS NOT DISTINCT FROM ?', 'temporary' => 'GLOBAL TEMPORARY ', # not dropped... + 'unlogged' => '', # ??? 'drop_table' => 'DROP TABLE', 'xor' => '???', 'sum' => 'SUM', # ??? too clever, detects integer overflows @@ -2364,7 +2384,8 @@ { $count = sql_do($dbh, $db, - "CREATE " . ($temp? $M{$db}{temporary}:'') . + "CREATE " . + ($temp? $M{$db}{temporary}: $unlog? $M{$db}{unlogged}: '') . "TABLE ${name}0 AS $build_checksum"); # count should be available somewhere, # but alas does not seem to be returned by do("CREATE TABLE ... AS ... ") @@ -2373,7 +2394,9 @@ elsif ($ckcmp eq 'insert' or not $M{$db}{create_as}) { sql_do($dbh, $db, - "CREATE ". ($temp? $M{$db}{temporary}: '')."TABLE ${name}0 (". + "CREATE ". + ($temp? $M{$db}{temporary}: $unlog? $M{$db}{unlogged}: '') . + "TABLE ${name}0 (". # KEY CHECKSUM NN? 'kcs ' . ($usekey? col_type($dbh, $dhpbt, $db, "@$pkeys"): $M{$db}{cktype}{4}) . @@ -2462,7 +2485,9 @@ } # create summary table my $create_table = - "CREATE " . ($temp? $M{$db}{temporary}:'') . "TABLE ${name}${level}"; + "CREATE " . + ($temp? $M{$db}{temporary}: $unlog? $M{$db}{unlogged}: '') . + "TABLE ${name}${level}"; # summary table contents my $select = "SELECT " . &{$M{$db}{andop}}($kcs, $masks[$level]) . " AS kcs, " . @@ -2482,7 +2507,7 @@ } # compute_summaries($dbh, $name, @masks) -# globals: $verb $temp $agg $cleanup +# globals: $verb $temp $unlog $agg $cleanup sub compute_summaries($$$$$@) { my ($dbh, $db, $name, $table, $skey, @masks) = @_; @@ -2792,6 +2817,7 @@ }, # auxiliary tables "temporary|temp|tmp|t!" => \$temp, + "unlogged|unlog|U!" => \$unlog, "cleanup!" => \$cleanup, "clear!" => \$clear, "prefix|p=s" => \$prefix, @@ -2831,6 +2857,9 @@ # handle stats option $stats = 'txt' if defined $stats and $stats eq ''; +die "--temporary and --unlogged are exclusive" + if $temp and $unlog; + die "invalid value for stats option: $stats for 'txt' or 'csv'" unless not defined $stats or $stats =~ /^(csv|txt)$/; -- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
