Annotation of /bin/CleanLog

#!/usr/bin/perl -w
# CleanLog
# Vadim Mikheev, (c) 2000, PostgreSQL Inc.

eval '(exit $?0)' && eval 'exec perl -S $0 ${1+"$@"}'
    & eval 'exec perl -S $0 $argv:q'
    if 0;

BEGIN {
        my $basedir = $0; $basedir =~ s#/[^/]+$##;
        unshift(@INC, "$basedir/../share");
}

use strict;
use Getopt::Long;
use RServ;

$| = 1;

my ($debug,$verbose) = (0,0);
my ($help,$masterhost,$masterport,$masteruser,$masterpassword);
my $snapshot = "__Snapshot";

my $result = GetOptions(
        "debug!" => \$debug, "verbose!" => \$verbose, "help" => \$help,
        "masterhost=s" => \$masterhost, "masterport=i" => \$masterport,
        "masteruser=s" => \$masteruser, "masterpassword=s" => \$masterpassword,
        "snapshot=s" => \$snapshot,
        );

if (defined($help) || (scalar(@ARGV) < 2) || ($ARGV[1] !~ /^\d+$/)) {
    print "Usage: $0 [options] masterdb syncid
Options:
        --masterhost=hostname --masterport=port
        --masteruser=username --masterpassword=string
        --snapshot=snapshot
";
    exit ((scalar(@ARGV) < 2)? 1:0);
}

$RServ::quiet = !$verbose;
if ($debug) {
        $RServ::quiet = 0;
        no warnings 'vars';
        $RServ::debug = $debug;
}

my $dbname = $ARGV[0];
my $howold = $ARGV[1];

my $minfo = "dbname=$dbname";
$minfo = "$minfo host=$masterhost" if (defined($masterhost));
$minfo = "$minfo port=$masterport" if (defined($masterport));
$minfo = "$minfo user=$masteruser" if (defined($masteruser));
$minfo = "$minfo password=$masterpassword" if (defined($masterpassword));

print "Master connection is $minfo\n" if ($debug);

my $conn = Pg::connectdb($minfo);

my $res = CleanLog($conn, $howold);

exit(1) if $res < 0;

printf STDERR "Deleted %d log records\n", $res if $res > 0;

exit(0);
1	dpavlin	1.4	#!/usr/bin/perl -w
2	dpavlin	1.1	# CleanLog
3			# Vadim Mikheev, (c) 2000, PostgreSQL Inc.
4
5			eval '(exit $?0)' && eval 'exec perl -S $0 ${1+"$@"}'
6			& eval 'exec perl -S $0 $argv:q'
7			if 0;
8
9	dpavlin	1.4	BEGIN {
10			my $basedir = $0; $basedir =~ s#/[^/]+$##;
11			unshift(@INC, "$basedir/../share");
12			}
13	dpavlin	1.1
14	dpavlin	1.4	use strict;
15	dpavlin	1.1	use Getopt::Long;
16			use RServ;
17
18			$\| = 1;
19
20	dpavlin	1.4	my ($debug,$verbose) = (0,0);
21			my ($help,$masterhost,$masterport,$masteruser,$masterpassword);
22			my $snapshot = "__Snapshot";
23
24			my $result = GetOptions(
25			"debug!" => \$debug, "verbose!" => \$verbose, "help" => \$help,
26			"masterhost=s" => \$masterhost, "masterport=i" => \$masterport,
27			"masteruser=s" => \$masteruser, "masterpassword=s" => \$masterpassword,
28			"snapshot=s" => \$snapshot,
29			);
30
31			if (defined($help) \|\| (scalar(@ARGV) < 2) \|\| ($ARGV[1] !~ /^\d+$/)) {
32			print "Usage: $0 [options] masterdb syncid
33			Options:
34			--masterhost=hostname --masterport=port
35			--masteruser=username --masterpassword=string
36			--snapshot=snapshot
37			";
38			exit ((scalar(@ARGV) < 2)? 1:0);
39	dpavlin	1.1	}
40
41	dpavlin	1.5	$RServ::quiet = !$verbose;
42			if ($debug) {
43			$RServ::quiet = 0;
44			no warnings 'vars';
45			$RServ::debug = $debug;
46			}
47
48	dpavlin	1.1	my $dbname = $ARGV[0];
49			my $howold = $ARGV[1];
50
51			my $minfo = "dbname=$dbname";
52	dpavlin	1.4	$minfo = "$minfo host=$masterhost" if (defined($masterhost));
53			$minfo = "$minfo port=$masterport" if (defined($masterport));
54			$minfo = "$minfo user=$masteruser" if (defined($masteruser));
55			$minfo = "$minfo password=$masterpassword" if (defined($masterpassword));
56	dpavlin	1.1
57			print "Master connection is $minfo\n" if ($debug);
58
59			my $conn = Pg::connectdb($minfo);
60
61	dpavlin	1.4	my $res = CleanLog($conn, $howold);
62	dpavlin	1.1
63			exit(1) if $res < 0;
64
65			printf STDERR "Deleted %d log records\n", $res if $res > 0;
66
67			exit(0);