3 # Vadim Mikheev, (c) 2000, PostgreSQL Inc.
5 eval '(exit $?0)' && eval 'exec perl -S $0 ${1+"$@"}'
6 & eval 'exec perl -S $0 $argv:q'
14 $result = GetOptions("debug!", "verbose!", "quiet!", "help",
15 "host=s", "user=s", "password=s");
17 my $debug = $opt_debug || 0;
18 my $verbose = $opt_verbose || 0;
19 my $quiet = $opt_quiet || 0;
21 if (defined($opt_help) || (scalar(@ARGV) < 1)) {
22 print "Usage: $0 --host=name --user=name --password=string slavedb\n";
23 exit ((scalar(@ARGV) < 1)? 1:0);
26 my $slave = $ARGV[0] || "slave";
28 my $sinfo = "dbname=$slave";
29 $sinfo = "$sinfo host=$opt_host" if (defined($opt_host));
30 $sinfo = "$sinfo user=$opt_user" if (defined($opt_user));
31 $sinfo = "$sinfo password=$opt_password" if (defined($opt_password));
36 print STDERR $conn->errorMessage;
37 $conn->exec("ROLLBACK");
41 print("Connecting to $sinfo\n") if ($debug || $verbose);
42 my $conn = Pg::connectdb($sinfo);
43 if ($conn->status != PGRES_CONNECTION_OK) {
44 print STDERR "Failed opening $sinfo\n";
48 my $result = $conn->exec("BEGIN");
49 RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
51 $result = $conn->exec("set transaction isolation level serializable");
52 RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
54 $result = $conn->exec("create table _RSERV_SLAVE_TABLES_" .
55 " (tname name, cname name, reloid oid, key int4)");
56 RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
58 $result = $conn->exec("create table _RSERV_SLAVE_SYNC_" .
59 " (syncid int4, synctime timestamp)");
60 RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);
62 $result = $conn->exec("COMMIT");
63 RollbackAndQuit($conn) if ($result->resultStatus ne PGRES_COMMAND_OK);