That does look like what i'm looking for, thanks!
Dave On Thursday, January 31, 2013 1:24:06 PM UTC-8, llowder wrote: > > > > On Thursday, January 31, 2013 3:10:12 PM UTC-6, David Kerr wrote: >> >> I am using PuppetDB and I'd love the links, I did some searching and >> wasn't able to find the conversation. >> >> Thanks for the reply! >> > > This may help. > > > https://ask.puppetlabs.com/question/88/how-can-i-purge-exported-resources-from-puppetdb/ > > >> >> >> On Thursday, January 31, 2013 12:55:54 PM UTC-8, Chris Price wrote: >>> >>> David, >>> >>> Are you using PuppetDB? There was a thread on this list recently about >>> the same topic, and there was some example SQL that could be used in the >>> short-term. We have a few open tickets around coming up with better >>> solutions for this and we expect to be addressing them Very Soon Now. If >>> you are using PuppetDB and you are interested in links (to either the >>> tickets or the previous thread) let me know and I'll dig them up. >>> >>> Thanks! >>> Chris >>> >>> On Thursday, January 31, 2013 10:26:18 AM UTC-8, David Kerr wrote: >>>> >>>> My environment heavily depends on exported resources to detect our >>>> mongo instances and to populate our haproxies. >>>> >>>> When we bring up and down nodes in AWS "puppet node clean" isn't >>>> cleaning up the exported resources so we get ghost >>>> machines loaded into those config files. >>>> >>>> Up until today I've attempted to limp along by doing: >>>> puppet node clean >>>> sudo puppet cert clean >>>> delete from catalog_resources where title like '%<hostname>%' >>>> delete from resource_params where value like '%<hostname>%' >>>> >>>> That's been "pretty good", but today I ran into a problem where even >>>> that didn't work. >>>> >>>> I'm comfortable working in the DB, but what's tough is trying to match >>>> the >>>> hashed ID's across tables (the data model doesn't make it exactly clear >>>> what's going on) >>>> >>>> If someone's already tackled this beast and has a script that does it >>>> right, that would be fantastic. >>>> I also understand that this is solved in 3.1, but I'm not too keen on >>>> upgrading to an RC just to >>>> get exported resources working correctly. >>>> >>>> If someone has insight into the data model and can help me fill the >>>> gaps that would be wonderful >>>> >>>> Thanks. >>>> >>> -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/puppet-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
