20 |
|
|
21 |
use Pg; |
use Pg; |
22 |
|
|
23 |
use lib '/usr/lib/postgresql/share/contrib/'; |
my $basedir; |
24 |
|
BEGIN { |
25 |
|
$basedir = $0; $basedir =~ s#/[^/]+$##; |
26 |
|
unshift(@INC, "$basedir/../share"); |
27 |
|
} |
28 |
|
#use lib '/usr/lib/postgresql/share/contrib/'; |
29 |
|
|
30 |
use RServ; |
use RServ; |
31 |
|
|
34 |
# G L O B A L V A R I A B L E S |
# G L O B A L V A R I A B L E S |
35 |
############################################################################## |
############################################################################## |
36 |
|
|
37 |
our $rserv_base = $0; |
our $master_sql = "$basedir/master.sql"; |
38 |
$rserv_base =~ s{[^/]*$}{RServ}; |
our $slave_sql = "$basedir/slave.sql"; |
|
|
|
|
our $master_sql = "$rserv_base/master.sql"; |
|
|
our $slave_sql = "$rserv_base/slave.sql"; |
|
39 |
our $db_changed = 0; |
our $db_changed = 0; |
40 |
|
|
41 |
|
|
256 |
|
|
257 |
print "Creating replication triggers\n"; |
print "Creating replication triggers\n"; |
258 |
|
|
259 |
my $cmnd = "$rserv_base/MasterAddTable"; |
my $cmnd = "$basedir/../bin/MasterAddTable"; |
260 |
$cmnd .= " --host=$opt{h}" if($opt{h}); |
$cmnd .= " --host=$opt{h}" if($opt{h}); |
261 |
$cmnd .= " --user=$opt{u}" if($opt{u}); |
$cmnd .= " --user=$opt{u}" if($opt{u}); |
262 |
$cmnd .= " --password=$opt{p}" if($opt{p}); |
$cmnd .= " --password=$opt{p}" if($opt{p}); |
285 |
|
|
286 |
print "Initialising slave tables\n"; |
print "Initialising slave tables\n"; |
287 |
|
|
288 |
my $cmnd = "$rserv_base/SlaveAddTable"; |
my $cmnd = "$basedir/../bin/SlaveAddTable"; |
289 |
$cmnd .= " --host=$opt{h}" if($opt{h}); |
$cmnd .= " --host=$opt{h}" if($opt{h}); |
290 |
$cmnd .= " --user=$opt{u}" if($opt{u}); |
$cmnd .= " --user=$opt{u}" if($opt{u}); |
291 |
$cmnd .= " --password=$opt{p}" if($opt{p}); |
$cmnd .= " --password=$opt{p}" if($opt{p}); |