All,

I have a need to create a script that automatically determines if slony
is installed and replicating on a specific database. The idea is that
another script that handles time partitioned table drops/creates could
call this script to determine if it needs to do any special slony
processing instead of its direct drop/create statements (i.e. pass the
SQL via slonik EXECUTE SCRIPT). I figure I'll be looking in the
information_schema schema for the current database. Is there any
particular place I should look (maybe the existence of an sl_status
table in information_schema.tables)? Any best practices would be great.

 

Thanks,

Doug Knight

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20081021/ba2781a7/attachment.htm