Cyril SCETBON scetbon at echo.fr
Mon Oct 6 08:42:59 PDT 2008
FYI,

I have used the following query to get the information :

select distinct tab_set as "set_id",array_to_string(array(select 
tab_relname from _mycluster.sl_table sl where 
sl.tab_set=t1.tab_set),',') as pkeyedtables,(select tab_id from 
_mycluster.sl_table sl where sl.tab_set=t1.tab_set limit 1) as table_id 
from _mycluster.sl_table t1;

This is what I used to start filling the $SLONY_SETS

Cyril SCETBON wrote:
> Hi guys,
>
> What's the easier way to generate this variable from a running 
> configuration ?
>
> Thanks

-- 
Cyril SCETBON


More information about the Slony1-general mailing list