Thanks for this. This exactly what I'm after!

Due to my own sloppiness I hadn't set up the slave correctly. It seems I
can rerun the same script. Is there a process I have to go through to
undo what has been done on the master so I can start from scratch from a
slony point of view?

TIA
Jase

> -----Original Message-----
> From: Thomas F. O'Connell [mailto:tfo at alumni.brown.edu]
> Sent: 11 June 2005 05:41
> To: Christopher Browne
> Cc: Tang, Jason; slony1-general at gborg.postgresql.org
> Subject: Re: [Slony1-general] (no subject)
> 
> A while back, I put together meta-slonik for just this purpose.
> 
> http://www.sitening.com/meta-slonik
> 
> --
> Thomas F. O'Connell
> Co-Founder, Information Architect
> Sitening, LLC
> 
> Strategic Open Source: Open Your i(tm)
> 
> http://www.sitening.com/
> 110 30th Avenue North, Suite 6
> Nashville, TN 37203-6320
> 615-260-0005
> 
> On Jun 10, 2005, at 1:25 PM, Christopher Browne wrote:
> 
> > Tang, Jason wrote:
> >
> >
> >> Hi All,
> >>
> >> I've been gifted with the task of implementing replication. I've
> >> had it
> >> replicating a simple db. However now I'm going to be doing it for
> >> real
> >> and the actual db has far too many tables/sequences to do it by
hand.
> >> I'm wondering if anyone out there has been through the exercise of
> >> writing something to pull out and generate a file to describe the
> >> set as
> >> a starting point.
> >>
> >> I thought I'd ask on here as it seems silly to potentially
> >> reinvent the
> >> wheel again. Any related links you guys could direct me towards
> >>
> >>
> >>
> > There's a tool in the "altperl" directory that is called
> > "build_env.pl"
> > or "slonik_build_env.pl" which tries to build a config file for the
> > "altperl" tools as a starting point for you.
> >
> > Other than that, it wouldn't be too hard to build a query that
> > rummages
> > around in the information_schema namespace for table and sequence
> > names
> > and generates, as output, a set of "set add table" and "set add
> > sequence" statements.