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.
