Marc G. Fournier scrappy
Sat Dec 4 20:34:39 PST 2004
Makes it alot easier when its only one or two tables out of several if you 
know when its going to pop up instead of 'randomly' :(


*** slony_setup.pl.orig Sat Dec  4 16:31:27 2004
--- slony_setup.pl      Sat Dec  4 16:31:39 2004
***************
*** 423,429 ****
           $data{'master'}{'databases'}{$database}{'all_tables'} = 1;
       } else {
           print "\nAdd tables in database $database to replication:\n";
!         foreach my $table (keys %{$data{'master'}{'databases'}{$database}{'tables'}}) {
               print " Add $database.$table? (Y|n) ";
               delete $data{'master'}{'databases'}{$database}{'tables'}{$table} if ! get_one_bool();
           }
--- 423,429 ----
           $data{'master'}{'databases'}{$database}{'all_tables'} = 1;
       } else {
           print "\nAdd tables in database $database to replication:\n";
!         foreach my $table (sort keys %{$data{'master'}{'databases'}{$database}{'tables'}}) {
               print " Add $database.$table? (Y|n) ";
               delete $data{'master'}{'databases'}{$database}{'tables'}{$table} if ! get_one_bool();
           }
***************
*** 439,445 ****
           $data{'master'}{'databases'}{$database}{'all_sequences'} = 1;
       } else {
           print "\nAdd sequences in database $database to replication:\n";
!         foreach my $sequence (keys %{$data{'master'}{'databases'}{$database}{'sequences'}}) {
               print " Add $sequence? (Y|n) ";
               delete $data{'master'}{'databases'}{$database}{'sequences'}{$sequence} if ! get_one_bool();
           }
--- 439,445 ----
           $data{'master'}{'databases'}{$database}{'all_sequences'} = 1;
       } else {
           print "\nAdd sequences in database $database to replication:\n";
!         foreach my $sequence (sort keys %{$data{'master'}{'databases'}{$database}{'sequences'}}) {
               print " Add $sequence? (Y|n) ";
               delete $data{'master'}{'databases'}{$database}{'sequences'}{$sequence} if ! get_one_bool();
           }



----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy at hub.org           Yahoo!: yscrappy              ICQ: 7615664


More information about the Slony1-general mailing list