Annotation of /bin/SlaveRemove

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

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

use strict;
use Pg;
use Getopt::Long;
use Sys::Hostname;

$| = 1;

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

my $result = GetOptions(
        "debug!" => \$debug, "verbose!" => \$verbose,
        "quiet!" => \$quiet, "help" => \$help,
        "masterhost=s" => \$masterhost, "masterport=i" => \$masterport,
        "masteruser=s" => \$masteruser, "masterpassword=s" => \$masterpassword,
        "slavehost=s" => \$slavehost, "slaveport=i" => \$slaveport,
        "slaveuser=s" => \$slaveuser, "slavepassword=s" => \$slavepassword,
        );

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

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

sub RollbackAndQuit {
    my $conn = shift @_;

    print STDERR $conn->errorMessage;
    $conn->exec("ROLLBACK");
    exit (-1);
}

# First, lets add the needed information in the slave database

print("Connecting to $sinfo\n") if ($debug || $verbose);
my $conn = Pg::connectdb($sinfo);
if ($conn->status != PGRES_CONNECTION_OK) {
    print STDERR "Failed opening $sinfo\n";
    exit 1;
}

$result = $conn->exec("BEGIN");
RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);

$result = $conn->exec("set transaction isolation level serializable");
RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);

$result = $conn->exec("DROP TABLE _RSERV_SLAVE_TABLES_");
RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);

$result = $conn->exec("DROP TABLE _RSERV_SLAVE_SYNC_");
RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);

$result = $conn->exec("COMMIT");
RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);


# next, let's tell the master that the slave is gone.

print("Connecting to $minfo\n") if ($debug || $verbose);
$conn = Pg::connectdb($minfo);
if ($conn->status != PGRES_CONNECTION_OK) {
    print STDERR "Failed opening $minfo\n";
    exit 1;
}


my $host = defined($slavehost) ? $slavehost : hostname;

$result = $conn->exec("DELETE FROM _RSERV_SERVERS_ WHERE host='$host' AND dbase='$slave'");
if ($result->resultStatus ne PGRES_COMMAND_OK) {
    print STDERR $conn->errorMessage;
    exit (-1);
}


exit (0);
1	dpavlin	1.2	#!/usr/bin/perl -w
2	dpavlin	1.1	# SlaveInit
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.2	use strict;
10	dpavlin	1.1	use Pg;
11			use Getopt::Long;
12			use Sys::Hostname;
13
14			$\| = 1;
15
16	dpavlin	1.2	my ($debug,$verbose,$quiet) = (0,0,0);
17			my ($help,$masterhost,$masterport,$masteruser,$masterpassword,
18			$slavehost,$slaveport,$slaveuser,$slavepassword);
19
20			my $result = GetOptions(
21			"debug!" => \$debug, "verbose!" => \$verbose,
22			"quiet!" => \$quiet, "help" => \$help,
23			"masterhost=s" => \$masterhost, "masterport=i" => \$masterport,
24			"masteruser=s" => \$masteruser, "masterpassword=s" => \$masterpassword,
25			"slavehost=s" => \$slavehost, "slaveport=i" => \$slaveport,
26			"slaveuser=s" => \$slaveuser, "slavepassword=s" => \$slavepassword,
27			);
28
29			if (defined($help) \|\| (scalar(@ARGV) < 2)) {
30			print "Usage: $0 [options] masterdb slavedb
31			Options:
32			--masterhost=hostname --masterport=port
33			--masteruser=username --masterpassword=string
34			--slavehost=hostname --slaveport=port
35			--slaveuser=username --slavepassword=string
36			";
37			exit ((scalar(@ARGV) < 2)? 1:0);
38	dpavlin	1.1	}
39
40			my $master = $ARGV[0] \|\| "master";
41			my $slave = $ARGV[1] \|\| "slave";
42
43	dpavlin	1.3	my $minfo = MkInfo($master,$masterhost,$masterport,$masteruser,$masterpassword);
44			my $sinfo = MkInfo($slave,$slavehost,$slaveport,$slaveuser,$slavepassword);
45	dpavlin	1.1
46			sub RollbackAndQuit {
47			my $conn = shift @_;
48
49			print STDERR $conn->errorMessage;
50			$conn->exec("ROLLBACK");
51			exit (-1);
52			}
53
54			# First, lets add the needed information in the slave database
55
56			print("Connecting to $sinfo\n") if ($debug \|\| $verbose);
57			my $conn = Pg::connectdb($sinfo);
58			if ($conn->status != PGRES_CONNECTION_OK) {
59			print STDERR "Failed opening $sinfo\n";
60			exit 1;
61			}
62
63	dpavlin	1.2	$result = $conn->exec("BEGIN");
64	dpavlin	1.1	RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
65
66			$result = $conn->exec("set transaction isolation level serializable");
67			RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
68
69			$result = $conn->exec("DROP TABLE _RSERV_SLAVE_TABLES_");
70			RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
71
72			$result = $conn->exec("DROP TABLE _RSERV_SLAVE_SYNC_");
73			RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
74
75			$result = $conn->exec("COMMIT");
76			RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
77
78
79			# next, let's tell the master that the slave is gone.
80
81			print("Connecting to $minfo\n") if ($debug \|\| $verbose);
82			$conn = Pg::connectdb($minfo);
83			if ($conn->status != PGRES_CONNECTION_OK) {
84			print STDERR "Failed opening $minfo\n";
85			exit 1;
86			}
87
88
89	dpavlin	1.2	my $host = defined($slavehost) ? $slavehost : hostname;
90	dpavlin	1.1
91			$result = $conn->exec("DELETE FROM _RSERV_SERVERS_ WHERE host='$host' AND dbase='$slave'");
92			if ($result->resultStatus ne PGRES_COMMAND_OK) {
93			print STDERR $conn->errorMessage;
94			exit (-1);
95			}
96
97
98			exit (0);