Contents of /bin/SlaveInit

#!/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;

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

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("create table _RSERV_SLAVE_TABLES_" .
                      " (tname name not null, cname name not null, reloid oid not null, key int4 not null)");
RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);

$result = $conn->exec("create table _RSERV_SLAVE_SYNC_" .
                      " (syncid int4 not null, synctime timestamp)");
RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);


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

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

$slavehost="localhost" if (! $slavehost);

$result = $mconn->exec("INSERT INTO _RSERV_SERVERS_ (host,dbase) VALUES ('$slavehost','$slave')");
if ($result->resultStatus ne PGRES_COMMAND_OK) {
    print STDERR $mconn->errorMessage;
    RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
#    exit (-1);
}


# then commit the slave transaction

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


exit (0);
1	#!/usr/bin/perl -w
2	# 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	use strict;
10	use Pg;
11	use Getopt::Long;
12
13	$\| = 1;
14
15	my ($debug,$verbose,$quiet) = (0,0,0);
16	my ($help,$masterhost,$masterport,$masteruser,$masterpassword,
17	$slavehost,$slaveport,$slaveuser,$slavepassword);
18
19	my $result = GetOptions(
20	"debug!" => \$debug, "verbose!" => \$verbose,
21	"quiet!" => \$quiet, "help" => \$help,
22	"masterhost=s" => \$masterhost, "masterport=i" => \$masterport,
23	"masteruser=s" => \$masteruser, "masterpassword=s" => \$masterpassword,
24	"slavehost=s" => \$slavehost, "slaveport=i" => \$slaveport,
25	"slaveuser=s" => \$slaveuser, "slavepassword=s" => \$slavepassword,
26	);
27
28	if (defined($help) \|\| (scalar(@ARGV) < 2)) {
29	print "Usage: $0 [options] masterdb slavedb
30	Options:
31	--masterhost=hostname --masterport=port
32	--masteruser=username --masterpassword=string
33	--slavehost=hostname --slaveport=port
34	--slaveuser=username --slavepassword=string
35	";
36	exit ((scalar(@ARGV) < 2)? 1:0);
37	}
38
39	my $master = $ARGV[0] \|\| "master";
40	my $slave = $ARGV[1] \|\| "slave";
41
42	my $sinfo = "dbname=$slave";
43	$sinfo = "$sinfo host=$slavehost" if (defined($slavehost));
44	$sinfo = "$sinfo port=$slaveport" if (defined($slaveport));
45	$sinfo = "$sinfo user=$slaveuser" if (defined($slaveuser));
46	$sinfo = "$sinfo password=$slavepassword" if (defined($slavepassword));
47
48	my $minfo = "dbname=$master";
49	$minfo = "$minfo host=$masterhost" if (defined($masterhost));
50	$minfo = "$minfo port=$masterport" if (defined($masterport));
51	$minfo = "$minfo user=$masteruser" if (defined($masteruser));
52	$minfo = "$minfo password=$masterpassword" if (defined($masterpassword));
53
54	sub RollbackAndQuit {
55	my $conn = shift @_;
56
57	print STDERR $conn->errorMessage;
58	$conn->exec("ROLLBACK");
59	exit (-1);
60	}
61
62	# First, lets add the needed information in the slave database
63
64	print("Connecting to $sinfo\n") if ($debug \|\| $verbose);
65	my $conn = Pg::connectdb($sinfo);
66	if ($conn->status != PGRES_CONNECTION_OK) {
67	print STDERR "Failed opening $sinfo\n";
68	exit 1;
69	}
70
71	$result = $conn->exec("BEGIN");
72	RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
73
74	$result = $conn->exec("set transaction isolation level serializable");
75	RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
76
77	$result = $conn->exec("create table _RSERV_SLAVE_TABLES_" .
78	" (tname name not null, cname name not null, reloid oid not null, key int4 not null)");
79	RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
80
81	$result = $conn->exec("create table _RSERV_SLAVE_SYNC_" .
82	" (syncid int4 not null, synctime timestamp)");
83	RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
84
85
86	# next, let's tell the master that the slave is set up.
87
88	print("Connecting to $minfo\n") if ($debug \|\| $verbose);
89	my $mconn = Pg::connectdb($minfo);
90	if ($mconn->status != PGRES_CONNECTION_OK) {
91	print STDERR "Failed opening $minfo\n";
92	RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
93	# exit 1;
94	}
95
96	$slavehost="localhost" if (! $slavehost);
97
98	$result = $mconn->exec("INSERT INTO _RSERV_SERVERS_ (host,dbase) VALUES ('$slavehost','$slave')");
99	if ($result->resultStatus ne PGRES_COMMAND_OK) {
100	print STDERR $mconn->errorMessage;
101	RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
102	# exit (-1);
103	}
104
105
106	# then commit the slave transaction
107
108	$result = $conn->exec("COMMIT");
109	RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
110
111
112
113	exit (0);