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.