=?iso-2022-jp?b?W3Bnc3FsLWpwOiAzNTc3OV0gIBskQi01ISElLyVpJTklPyE8?= =?iso-2022-jp?b?JE46bz18GyhCGyRCJEskRCQkJEYbKEI=?=

[sakurai ＠ mxs.nes.nec.co.jp]

slony-$B-5!!%/%i%9%?!<$N:o=|$K$D$$$F!!65$($F$$$?$@$-$?$$$3$H$,$"$j$^$9!#(B

$B%5%s%W%k$r8+$J$,$i%/%i%9%?!<$rDj5A$7!"%G!<%b%s$rF0$+$7$F(B
$B%l%W%j%1!<%7%g%s$K$O ＠ .8y$7$?$N$G$9$,!"%F%9%H$G$?$/$5$s(B
$B%/%i%9%?!<$r:n ＠ .$7$F$7$^$$!"$=$l$r:o=|$7$?$$$N$G$9$,!"(B
$BJ}K!$,$o$+$j$^$;$s!#(B

$B%X%k%W$K$O(B set drop table$B!!%3%^%s%I$r;H$&!!$H$"$C$?$N$G<!$N$h$&$K(B
$B%W%m%0%i%`$rF0$+$7$?$N$G$9$,!"<B9T7k2L$O%(%i!<$G$7$?!#(B

 "_test161".setDropTable(1);  - ERROR:  Slony-I: setDropTable_int(): table 1 not found


    
slonik <<_EOF_

cluster name = $CLUSTER;

node 1 admin conninfo = 'dbname=$DB1 host=$HOST1 user=$RUSER';
node 2 admin conninfo = 'dbname=$DB2 host=$HOST2 user=$RUSER';

init cluster (id = 1, comment = 'Node 1');


    SET DROP TABLE ( 
    ORIGIN = 1, 
    ID = 1);

_EOF_


$B$^$?!"(BDB$B$r$N$>$/$H!"%*!<%J!<$,(Bpgsql$B!J%G%U%)%k%H$O(Bpostgres)$B$G(B
sl_set, sl_sequence$B!!$J$I$N%F!<%V%k$,(Bnspname=$B%/%i%9%?!<L>!!$G(B
$B$?$/$5$s$G$-$F$$$^$9!J%F%9%H$G$?$/$5$s:n ＠ .$7$F$7$^$C$?$?$a!K(B
$B$3$l$i$N%F!<%V%k$O!"(BCSE$B$J$I$N%D!<%k$G%j%9%H$K$O=P$F$/$k$N$G$9$,(B
$BCf?H$r8+$h$&$H$9$k$H!"(B

SQL$B<B9TCf$K0J2<$N%(%i!<$,H/@8$7$^$7$?!#(B
ERROR:  relation "sl_table" does not exist

$B$H$J$j$^$9!#(B
$B$I$&$9$l$P!":n ＠ .$7$?BgNL$N%/%i%9%?!<$r:o=|$G$-$k$N$G$7$g$&$+!#(B
$B$h$m$7$/$*4j$$$7$^$9!#(B