On Tuesday September 21 2004 7:24, Jan Wieck wrote:
> > When I drop the slave's replication schema, "pg_dump -s foo" does not
> > show any trace whatsoever of any slony schema, triggers, etc.  I would
> > have expected the dependency to show up in the dump.  What am I
> > missing?  Here's what I'm doing:
>
> Have a single "user-defined" trigger on a table, just some no-op thing.
> Then install slony, drop the replication schema on the slave and dump
> the result ...

Now I see it, thx.  

So, is the following the standard form to remove all replication schema, 
columns, etc, and return DB to what it was before?

  slonik <<_EOF_
    cluster name = replication;
    node 2 admin conninfo = '$SLAVE_CONNINFO';
    uninstall node ( id = 2 );
_EOF_

Ed