Annotation of /bin/Replicate

#!/usr/bin/perl -w
# Replicate
# 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 = ".__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)) {
    print "Usage: $0 [options] masterdb slavedb
Options:
        --masterhost=hostname --masterport=port
        --masteruser=username --masterpassword=string
        --snapshot=snapshot
";
    exit ((scalar(@ARGV) < 2)? 1:0);
}

$snapshot .= '.' . $$;

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

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

# first, let's check if a instance is alrealy running

my $str = $master;
$str .= '@'.$masterhost if (defined($masterhost));
$str .= ':'.$slave;
$str .= '@'.$slavehost if (defined($slavehost));
my $fname = "/tmp/.lock_rserv-$str";
if (-e $fname) {
    print STDERR "rServ is already running for $str. Remove $fname to override this.\n";
    exit(1);
}
open ARQ, ">$fname" || die "Cannot open $fname: $!\n";
print ARQ "$$\n";
close ARQ;

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

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

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

my $slaveId = GetSlaveId($mconn, $slave, defined($slavehost) ? $slavehost : hostname);
if ($slaveId < 0) {
    unlink $fname;
    die "\n>>>>>>>>>>>>> ERROR\n";
}
SyncSync($mconn, $sconn);

my $outf = new IO::File;
open $outf, ">$snapshot";
print "\n>>>>>>>>>>>>> Prepare Snapshot\n\n" if ($verbose);
my $res = PrepareSnapshot($mconn, $sconn, $outf, $slaveId);
close $outf;
if ($res < 0) {
    unlink $fname;
    die "\n>>>>>>>>>>>>> ERROR\n";
}
if ($res == 0)
{
    print "\n>>>>>>>>>>>>> DBases are sync-ed\n" if ($verbose);
    unlink $snapshot unless ($debug);
    unlink $fname;
    exit(0);
}

my $inpf = new IO::File;
open $inpf, "<$snapshot";
print "\n>>>>>>>>>>>>> Apply Snapshot\n\n" if ($verbose);
$res = ApplySnapshot($sconn, $inpf);
close $inpf;
if ($res < 0) {
    unlink $fname;
    die "\n>>>>>>>>>>>>> ERROR\n";
}

if ($res > 0)
{
    print "Snapshot applied\n" if ($verbose);
    unlink $snapshot unless ($debug);
    SyncSync($mconn, $sconn);
}

unlink $fname;
exit(0);

###########################################################################

sub SyncSync
{
    ($mconn, $sconn) = @_;

    print "\n>>>>>>>>>>>>> Sync SyncID\n\n" if ($verbose);
    print "Get last SyncID from Slave DB\n" if ($verbose);
    my $syncid = GetSyncID($sconn);
    if ($syncid && $syncid > 0)
    {
        print "Last SyncID applied: $syncid\n" if ($verbose);
        print "Sync SyncID\n" if ($verbose);

        $res = SyncSyncID($mconn, $slaveId, $syncid);

        print "Succeeded\n" if (($res > 0) && ($verbose));
    }
}
1	dpavlin	1.6	#!/usr/bin/perl -w
2	dpavlin	1.1	# Replicate
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.5	BEGIN {
10			my $basedir = $0; $basedir =~ s#/[^/]+$##;
11			unshift(@INC, "$basedir/../share");
12			}
13	dpavlin	1.1
14	dpavlin	1.6	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.6	my ($debug,$verbose) = (0,0);
23			my ($help,$masterhost,$masterport,$masteruser,$masterpassword,
24			$slavehost,$slaveport,$slaveuser,$slavepassword);
25			my $snapshot = ".__Snapshot";
26
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			"snapshot=s" => \$snapshot,
32			);
33
34			if (defined($help) \|\| (scalar(@ARGV) < 2)) {
35			print "Usage: $0 [options] masterdb slavedb
36			Options:
37			--masterhost=hostname --masterport=port
38			--masteruser=username --masterpassword=string
39			--snapshot=snapshot
40			";
41			exit ((scalar(@ARGV) < 2)? 1:0);
42			}
43
44	dpavlin	1.3	$snapshot .= '.' . $$;
45	dpavlin	1.1
46	dpavlin	1.6	$RServ::quiet = !$verbose;
47			if ($debug) {
48			$RServ::quiet = 0;
49			no warnings 'vars';
50			$RServ::debug = $debug;
51	dpavlin	1.1	}
52
53			my $master = $ARGV[0] \|\| "master";
54			my $slave = $ARGV[1] \|\| "slave";
55	dpavlin	1.3
56			# first, let's check if a instance is alrealy running
57
58	dpavlin	1.7	my $str = $master;
59			$str .= '@'.$masterhost if (defined($masterhost));
60			$str .= ':'.$slave;
61			$str .= '@'.$slavehost if (defined($slavehost));
62	dpavlin	1.3	my $fname = "/tmp/.lock_rserv-$str";
63			if (-e $fname) {
64			print STDERR "rServ is already running for $str. Remove $fname to override this.\n";
65			exit(1);
66			}
67			open ARQ, ">$fname" \|\| die "Cannot open $fname: $!\n";
68			print ARQ "$$\n";
69			close ARQ;
70	dpavlin	1.1
71			my $minfo = "dbname=$master";
72	dpavlin	1.6	$minfo = "$minfo host=$masterhost" if (defined($masterhost));
73			$minfo = "$minfo port=$masterport" if (defined($masterport));
74			$minfo = "$minfo user=$masteruser" if (defined($masteruser));
75			$minfo = "$minfo password=$masterpassword" if (defined($masterpassword));
76
77	dpavlin	1.1	my $sinfo = "dbname=$slave";
78	dpavlin	1.6	$sinfo = "$sinfo host=$slavehost" if (defined($slavehost));
79			$sinfo = "$sinfo port=$slaveport" if (defined($slaveport));
80			$sinfo = "$sinfo user=$slaveuser" if (defined($slaveuser));
81			$sinfo = "$sinfo password=$slavepassword" if (defined($slavepassword));
82	dpavlin	1.1
83			print "Master connection is $minfo\n" if ($debug);
84			print "Slave connection is $sinfo\n" if ($debug);
85
86			my $mconn = Pg::connectdb($minfo);
87	dpavlin	1.6	if ($mconn->status != Pg::PGRES_CONNECTION_OK) {
88	dpavlin	1.3	print STDERR "Failed opening $minfo\n";
89			unlink $fname;
90			exit 1;
91			}
92	dpavlin	1.1	my $sconn = Pg::connectdb($sinfo);
93	dpavlin	1.6	if ($sconn->status != Pg::PGRES_CONNECTION_OK) {
94	dpavlin	1.3	print STDERR "Failed opening $sinfo\n";
95			unlink $fname;
96			exit 1;
97			}
98	dpavlin	1.1
99	dpavlin	1.6	my $slaveId = GetSlaveId($mconn, $slave, defined($slavehost) ? $slavehost : hostname);
100	dpavlin	1.3	if ($slaveId < 0) {
101			unlink $fname;
102			die "\n>>>>>>>>>>>>> ERROR\n";
103			}
104	dpavlin	1.1	SyncSync($mconn, $sconn);
105
106			my $outf = new IO::File;
107			open $outf, ">$snapshot";
108			print "\n>>>>>>>>>>>>> Prepare Snapshot\n\n" if ($verbose);
109	dpavlin	1.6	my $res = PrepareSnapshot($mconn, $sconn, $outf, $slaveId);
110	dpavlin	1.1	close $outf;
111	dpavlin	1.3	if ($res < 0) {
112			unlink $fname;
113			die "\n>>>>>>>>>>>>> ERROR\n";
114			}
115	dpavlin	1.1	if ($res == 0)
116			{
117	dpavlin	1.3	print "\n>>>>>>>>>>>>> DBases are sync-ed\n" if ($verbose);
118			unlink $snapshot unless ($debug);
119			unlink $fname;
120			exit(0);
121	dpavlin	1.1	}
122
123			my $inpf = new IO::File;
124			open $inpf, "<$snapshot";
125			print "\n>>>>>>>>>>>>> Apply Snapshot\n\n" if ($verbose);
126			$res = ApplySnapshot($sconn, $inpf);
127			close $inpf;
128	dpavlin	1.3	if ($res < 0) {
129			unlink $fname;
130			die "\n>>>>>>>>>>>>> ERROR\n";
131			}
132	dpavlin	1.1
133			if ($res > 0)
134			{
135	dpavlin	1.3	print "Snapshot applied\n" if ($verbose);
136			unlink $snapshot unless ($debug);
137			SyncSync($mconn, $sconn);
138	dpavlin	1.1	}
139
140	dpavlin	1.3	unlink $fname;
141	dpavlin	1.1	exit(0);
142
143			###########################################################################
144
145			sub SyncSync
146			{
147			($mconn, $sconn) = @_;
148
149			print "\n>>>>>>>>>>>>> Sync SyncID\n\n" if ($verbose);
150			print "Get last SyncID from Slave DB\n" if ($verbose);
151	dpavlin	1.6	my $syncid = GetSyncID($sconn);
152	dpavlin	1.7	if ($syncid && $syncid > 0)
153	dpavlin	1.1	{
154			print "Last SyncID applied: $syncid\n" if ($verbose);
155			print "Sync SyncID\n" if ($verbose);
156
157	dpavlin	1.3	$res = SyncSyncID($mconn, $slaveId, $syncid);
158	dpavlin	1.1
159			print "Succeeded\n" if (($res > 0) && ($verbose));
160			}
161			}