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;

$| = 1;

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

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

if (defined($help) || (scalar(@ARGV) < 2)) {
    print "Usage: $0 [options] masterdb slavedb
Options:
        --masterhost=hostname --masterport=port
        --masteruser=username --masterpassword=string
        --multimaster
        --snapshot=snapshot
";
    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 = MkInfo($master,$masterhost,$masterport,$masteruser,$masterpassword);
my $sinfo = MkInfo($slave,$slavehost,$slaveport,$slaveuser,$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;
}

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

$masterhost = 'localhost' if (! $masterhost);
my $masterId  = GetServerId($mconn, $master, $masterhost);
if (! defined($masterId)) {
        print STDERR "Can't find masterId for db '$master' on host $masterhost. Is this database master?\n";
        exit 1;
}
die "Unknown masterId $masterId for host $masterhost" if ($masterId < 0);
my $res = PrepareSnapshot ($mconn, $sconn, $outf, $masterId, $slaveId, $multimaster);

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