Mon Aug 4 04:45:58 PDT 2008
- Previous message: [Slony1-general] REPAIR CONFIG function
- Next message: [Slony1-general] consulta slony a la inversa
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] REPAIR CONFIG function
- Next message: [Slony1-general] consulta slony a la inversa
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list