/[rserv]/bin/PrepareSnapshot
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /bin/PrepareSnapshot

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.13 - (show annotations)
Sun Nov 2 21:07:14 2003 UTC (20 years, 5 months ago) by dpavlin
Branch: MAIN
CVS Tags: HEAD
Changes since 1.12: +4 -4 lines
first multi-master version which pass regression tests (that doesn't
mean working; tests might just be too little...)
renamed multiplemaster to simple multimaster

1 #!/usr/bin/perl -w
2 # 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 BEGIN {
10 my $basedir = $0; $basedir =~ s#/[^/]+$##;
11 unshift(@INC, "$basedir/../share");
12 }
13
14 use strict;
15 use IO::File;
16 use Getopt::Long;
17 use RServ;
18
19 $| = 1;
20
21 my ($debug,$verbose) = (0,0);
22 my ($help,$masterhost,$masterport,$masteruser,$masterpassword,
23 $slavehost,$slaveport,$slaveuser,$slavepassword,
24 $multimaster,$snapshot,
25 );
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 "multimaster" => \$multimaster,
32 "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 --multimaster
41 --snapshot=snapshot
42 ";
43 exit ((scalar(@ARGV) < 2)? 1:0);
44 }
45
46 $RServ::quiet = !$verbose;
47 if ($debug) {
48 $RServ::quiet = 0;
49 no warnings 'vars';
50 $RServ::debug = $debug;
51 }
52
53 my $master = $ARGV[0] || "master";
54 my $slave = $ARGV[1] || "slave";
55
56 my $minfo = MkInfo($master,$masterhost,$masterport,$masteruser,$masterpassword);
57 my $sinfo = MkInfo($slave,$slavehost,$slaveport,$slaveuser,$slavepassword);
58
59 my $mconn = Pg::connectdb($minfo);
60 if ($mconn->status != Pg::PGRES_CONNECTION_OK) {
61 print STDERR "Failed opening $minfo\n";
62 exit 1;
63 }
64 my $sconn = Pg::connectdb($sinfo);
65 if ($sconn->status != Pg::PGRES_CONNECTION_OK) {
66 print STDERR "Failed opening $minfo\n";
67 exit 1;
68 }
69
70 my $outf;
71 if (defined($snapshot)) {
72 $outf = new IO::File;
73 $outf->open("> $snapshot");
74 } else {
75 $outf = *STDOUT;
76 }
77
78 $slavehost = 'localhost' if (! $slavehost);
79 my $slaveId = GetServerId($mconn, $slave, $slavehost);
80 if (! defined($slaveId)) {
81 print STDERR "Can't find SlaveId for db '$slave' on host $slavehost. Is this database slave?\n";
82 exit 1;
83 }
84 die "Unknown SlaveId $slaveId for host $slavehost" if ($slaveId < 0);
85
86 $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 my $res = PrepareSnapshot ($mconn, $sconn, $outf, $masterId, $slaveId, $multimaster);
94
95 if ($res == 0)
96 {
97 printf STDERR "Sync-ed\n";
98 exit(0);
99 }
100 if ($res > 0)
101 {
102 printf STDERR "Snapshot dumped.\n";
103 exit(0);
104 }
105
106 printf STDERR "ERROR\n";
107 exit(1);

  ViewVC Help
Powered by ViewVC 1.1.26