Thomas F.O'Connell tfo
Wed Nov 24 06:41:25 PST 2004
Not sure if this is the same thing, but I wrote a little utility called 
meta-slonik a while back that grabs sequences, constrained tables, and 
unconstrained tables and handles them all appropriately in a single 
slonik script designed for use with a single master and slave.

http://www.sitening.com/meta-slonik

I haven't tested or updated this since slony1-1.0.2, though.

Is this worth adding to altperl? If so, I can certainly document it 
better. Comments welcome, of course. Clearly, it could be expanded to 
handle more complicated slony setups.

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Nov 22, 2004, at 10:20 AM, Darcy Buskermolen wrote:

> On November 22, 2004 07:31 am, Marc G. Fournier wrote:
>> Basically, adding a complete database without having to a seperate 
>> 'add
>> table' for each table in the database ...
>>
>> Is that possible?  If not, is there any work being done towards that 
>> end?
>
> Currently, no that's not possible, nor should it be provided in 
> slonik.  if
> you want to do this kind of thing easily, why not not build a simple 
> script
> to do a SELECT from the information schema, and have it output all the 
> add
> table commands.
>
> I think elein's general bits has a link to a tool mentions on this 
> list called
> metaslony.pl (or the like) that does exactly this.



More information about the Slony1-general mailing list