Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have setup stored configuration primarily as a method to manage my ssh known_hosts. Unfortunately as I retire hosts the old configs still exist in my database. The answer seems to be run the command puppet node clean <hostname>.

The problem is that while this does command does run, and does clean up some data, it doesn't seem to clean up everything.

For example I can still find values in the puppet_tags table that only applied to a hosts that no longer exists.

What should I be doing to keep my stored configuration database clean of all extra junk that seems to be building up?

P.S. Can anyone point me any documentation for the stored configuration schema?  If I could find good documentation, or at least an entity-relationship-diagram, I would be tempted to just do some manual clean-up.

share|improve this question
    
The requirements of this question are not specific. What are all of the tables/fields that have extra data building up? –  Barry Oct 21 '12 at 8:42
add comment

1 Answer

up vote 2 down vote accepted
+50

Storedconfigs are stored as activerecord models.

Here's the schema:

https://github.com/puppetlabs/puppet/blob/master/lib/puppet/rails/database/schema.rb

If you really want an ER diagram, it can be extracted from the source with something like http://rails-erd.rubyforge.org

share|improve this answer
    
This is useful, and I am awarding the bounty since it would be lost other wise. I am not going to mark this as accepted though since it doesn't really answer the core question about cleaning up some of the extra cruft. –  Zoredache Oct 18 '12 at 20:11
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.