Glyn Astill glynastill at yahoo.co.uk
Mon Aug 4 04:45:58 PDT 2008
Seems to do the trick. Rather than just drop my replication schema, I now do the following.

select (_main_replication.updatereloid(set_id,1)) from _main_replication.sl_set;

select _main_replication.uninstallnode();

drop schema _main_replication cascade;



--- On Mon, 4/8/08, "Stéphane A. Schildknecht" <stephane.schildknecht at postgresqlfr.org> wrote:

> From: "Stéphane A. Schildknecht" <stephane.schildknecht at postgresqlfr.org>
> Subject: Re: [Slony1-general] REPAIR CONFIG function
> To: glynastill at yahoo.co.uk
> Cc: slony1-general at lists.slony.info
> Date: Monday, 4 August, 2008, 10:01 AM
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Glyn Astill a écrit :
> > Is there a baremetal function, or collection of
> functions that I can call to do the equivalent?
> > 
> > 
> >      
> __________________________________________________________
> > Not happy with your email address?.
> > Get the one you really want - millions of new email
> addresses available now at Yahoo!
> http://uk.docs.yahoo.com/ymail/new.html
> > _______________________________________________
> > Slony1-general mailing list
> > Slony1-general at lists.slony.info
> >
> http://lists.slony.info/mailman/listinfo/slony1-general
> 
> Hi,
> 
> I think you are looking for : updatereloid( integer,
> integer ) (see
> http://slony.info/documentation/function.updatereloid-integer-integer.html
> ).
> 
> I found that in slony sources for repair_config :
> 
>        slon_mkquery(&query,
>                                  "select
> \"_%s\".updateReloid(%d, %d); ",
>                                 
> stmt->hdr.script->clustername,
>                                  stmt->set_id,
> stmt->only_on_node);
> 
> 
> Regards,
> - --
> Stéphane Schildknecht
> PostgreSQLFr : http://www.postgresql.fr
> 
> Venez nous rencontrer le 4 octobre lors du plus important
> événement
> PostgreSQL francophone : http://www.pgday.fr
> 
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
> Comment: Using GnuPG with Mozilla -
> http://enigmail.mozdev.org
> 
> iD8DBQFIlsVpA+REPKWGI0ERAk5kAJ0emCKVkpu3c+qzb3Bz+l9O/nTWYACeIqq3
> QZilZGP16/Ia6AfuMDSN/mQ=
> =uGCJ
> -----END PGP SIGNATURE-----


      __________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html


More information about the Slony1-general mailing list