Wed Nov 24 06:41:25 PST 2004
- Previous message: [Slony1-general] add table public.* ... or even *.*
- Next message: [Slony1-general] Problems Setting up Slony
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [Slony1-general] add table public.* ... or even *.*
- Next message: [Slony1-general] Problems Setting up Slony
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list