Annotation of /bin/PrepareSnapshot

#!/usr/bin/perl -w
# PrepareSnapshot
# 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 IO::File;
use Getopt::Long;
use RServ;
use Sys::Hostname;

$| = 1;

my ($debug,$verbose) = (0,0);
my ($help,$masterhost,$masterport,$masteruser,$masterpassword,
        $slavehost,$slaveport,$slaveuser,$slavepassword);
my $snapshot;
my $mserver = 0;

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

if (defined($help) || (scalar(@ARGV) < 2)) {
    print "Usage: $0 [options] masterdb slavedb
Options:
        --masterhost=hostname --masterport=port
        --masteruser=username --masterpassword=string
        --snapshot=snapshot
        [--masterserver=master_number]
";
    exit ((scalar(@ARGV) < 2)? 1:0);
}

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

my $master = $ARGV[0] || "master";
my $slave = $ARGV[1] || "slave";

my $minfo = "dbname=$master";
$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));

my $sinfo = "dbname=$slave";
$sinfo = "$sinfo host=$slavehost" if (defined($slavehost));
$sinfo = "$sinfo port=$slaveport" if (defined($slaveport));
$sinfo = "$sinfo user=$slaveuser" if (defined($slaveuser));
$sinfo = "$sinfo password=$slavepassword" if (defined($slavepassword));

my $mconn = Pg::connectdb($minfo);
if ($mconn->status != Pg::PGRES_CONNECTION_OK) {
    print STDERR "Failed opening $minfo\n";
    exit 1;
}
my $sconn = Pg::connectdb($sinfo);
if ($sconn->status != Pg::PGRES_CONNECTION_OK) {
    print STDERR "Failed opening $minfo\n";
    exit 1;
}

my $outf;
if (defined($snapshot)) {
    $outf = new IO::File;    
    $outf->open("> $snapshot");
} else {
    $outf = *STDOUT;
}

my $hostname = defined($slavehost) ? $slavehost : hostname;
my $slaveId  = GetSlaveId($mconn, $slave, $hostname);
if (! $slaveId) {
        print STDERR "Can't find SlaveId for db '$slave' on host $hostname. Is this database slave?\n";
        exit 1;
}
die "Unknown SlaveId $slaveId for host $hostname" if ($slaveId < 0);

my $res = PrepareSnapshot ($mconn, $sconn, $outf, $mserver, $slaveId);

if ($res == 0)
{
    printf STDERR "Sync-ed\n";
    exit(0);
}
if ($res > 0)
{
    printf STDERR "Snapshot dumped.\n";
    exit(0);
}

printf STDERR "ERROR\n";
exit(1);
1	dpavlin	1.4	#!/usr/bin/perl -w
2	dpavlin	1.1	# PrepareSnapshot
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 IO::File;
16			use Getopt::Long;
17			use RServ;
18	dpavlin	1.3	use Sys::Hostname;
19	dpavlin	1.1
20			$\| = 1;
21
22	dpavlin	1.4	my ($debug,$verbose) = (0,0);
23			my ($help,$masterhost,$masterport,$masteruser,$masterpassword,
24			$slavehost,$slaveport,$slaveuser,$slavepassword);
25	dpavlin	1.6	my $snapshot;
26	dpavlin	1.7	my $mserver = 0;
27	dpavlin	1.4
28			my $result = GetOptions(
29			"debug!" => \$debug, "verbose!" => \$verbose, "help" => \$help,
30			"masterhost=s" => \$masterhost, "masterport=i" => \$masterport,
31			"masteruser=s" => \$masteruser, "masterpassword=s" => \$masterpassword,
32			"snapshot=s" => \$snapshot,
33	dpavlin	1.7	"masterserver=i" => \$mserver,
34	dpavlin	1.4	);
35
36			if (defined($help) \|\| (scalar(@ARGV) < 2)) {
37			print "Usage: $0 [options] masterdb slavedb
38			Options:
39			--masterhost=hostname --masterport=port
40			--masteruser=username --masterpassword=string
41			--snapshot=snapshot
42	dpavlin	1.7	[--masterserver=master_number]
43	dpavlin	1.4	";
44			exit ((scalar(@ARGV) < 2)? 1:0);
45	dpavlin	1.1	}
46
47	dpavlin	1.5	$RServ::quiet = !$verbose;
48			if ($debug) {
49			$RServ::quiet = 0;
50			no warnings 'vars';
51			$RServ::debug = $debug;
52			}
53
54	dpavlin	1.1	my $master = $ARGV[0] \|\| "master";
55	dpavlin	1.3	my $slave = $ARGV[1] \|\| "slave";
56	dpavlin	1.1
57			my $minfo = "dbname=$master";
58	dpavlin	1.4	$minfo = "$minfo host=$masterhost" if (defined($masterhost));
59			$minfo = "$minfo port=$masterport" if (defined($masterport));
60			$minfo = "$minfo user=$masteruser" if (defined($masteruser));
61			$minfo = "$minfo password=$masterpassword" if (defined($masterpassword));
62	dpavlin	1.3
63			my $sinfo = "dbname=$slave";
64	dpavlin	1.4	$sinfo = "$sinfo host=$slavehost" if (defined($slavehost));
65			$sinfo = "$sinfo port=$slaveport" if (defined($slaveport));
66			$sinfo = "$sinfo user=$slaveuser" if (defined($slaveuser));
67			$sinfo = "$sinfo password=$slavepassword" if (defined($slavepassword));
68	dpavlin	1.3
69			my $mconn = Pg::connectdb($minfo);
70	dpavlin	1.4	if ($mconn->status != Pg::PGRES_CONNECTION_OK) {
71	dpavlin	1.3	print STDERR "Failed opening $minfo\n";
72			exit 1;
73			}
74			my $sconn = Pg::connectdb($sinfo);
75	dpavlin	1.4	if ($sconn->status != Pg::PGRES_CONNECTION_OK) {
76	dpavlin	1.3	print STDERR "Failed opening $minfo\n";
77			exit 1;
78			}
79	dpavlin	1.1
80	dpavlin	1.3	my $outf;
81	dpavlin	1.4	if (defined($snapshot)) {
82	dpavlin	1.3	$outf = new IO::File;
83	dpavlin	1.4	$outf->open("> $snapshot");
84	dpavlin	1.3	} else {
85	dpavlin	1.4	$outf = *STDOUT;
86	dpavlin	1.3	}
87	dpavlin	1.1
88	dpavlin	1.4	my $hostname = defined($slavehost) ? $slavehost : hostname;
89			my $slaveId = GetSlaveId($mconn, $slave, $hostname);
90			if (! $slaveId) {
91			print STDERR "Can't find SlaveId for db '$slave' on host $hostname. Is this database slave?\n";
92			exit 1;
93			}
94	dpavlin	1.3	die "Unknown SlaveId $slaveId for host $hostname" if ($slaveId < 0);
95	dpavlin	1.2
96	dpavlin	1.7	my $res = PrepareSnapshot ($mconn, $sconn, $outf, $mserver, $slaveId);
97	dpavlin	1.1
98			if ($res == 0)
99			{
100	dpavlin	1.3	printf STDERR "Sync-ed\n";
101			exit(0);
102	dpavlin	1.1	}
103			if ($res > 0)
104			{
105	dpavlin	1.3	printf STDERR "Snapshot dumped.\n";
106			exit(0);
107	dpavlin	1.1	}
108
109			printf STDERR "ERROR\n";
110			exit(1);