[Puppet Users] Help me (fully) clear out stored configs from PuppetDB Postgresql

Hi all,

I recently started using the Nagios resources to populate a monitoring
server. I cycle hosts fairly quickly in my environment so already I've had
five hosts come and go from under Nagios. After a fair amount of searching
I discovered "puppet node deactivate" and performed same on the removed
hosts -- I'm still trying to figure out how to make that part of the
process going forward -- but somehow only one of my five hosts ended up
being removed from my Nagios configs. I am using resource { purge => true
} for the affected resource types.

So here's where I'm at -- if I run puppet node status <node> on any of
these missing hosts, they appear as "deactivated". If I clear out my
nagios config files and re-run puppet agent, the nodes and their services
(I did have an exported nagios_service resource when these hosts were
alive, which I've since removed -- in case that matters) will re-appear.
I've tried *puppet node clean*, *puppet node destroy*, *puppet node
deactivate*, with and without terminus=puppetdb. I can see in the puppetdb
log that it has received multiple deactivate commands for these hosts.
Nonetheless, the items are still appearing when the nagios host performs a
collection. I've got to put an end to that!

An example of puppet node status for one of the affected:

# puppet node status [badnodename]
[badnodename]
Deactivated at 2013-04-03T23:00:55.349Z
No catalog received
No facts received


One interesting bit. First, when I run puppet agent --test, during catalog
compilation I _was_ seeing the following for all four affected hosts:

warning: Nagios_service check_ssh_[badhost] found in both naginator and
naginator; skipping the naginator version


Out of frustration, I disabled storedconfigurations on the puppet master
and restarted it. After a few catalogs had processed, I updated Nagios
after manually purging the hosts file. As expected, all my host and
service definitions disappeared. I then re-enabled storedconfigurations,
fingers-crossed that the old host defs would be gone -- to my dismay, they
reappeared on the *second* catalog run after I brought stored_configs back
online. Now, I no longer get the error message above, but I do still get
the deactivated hosts and associated services.

At this point, I'd be happy to simply wipe all of my existing stored
configurations, as I suspect these four hosts have gotten themselves into
some kind of limbo. However, while the instructions for removing stored
config data from the old MySQL puppet db is quite straightforward, it
doesn't seem to map to the postgresql DB schema, and I can't find any
advice on how to go about wiping it there. I'd prefer not to just scrap my
database, but I'm getting closer to that point.

Any help would be appreciated.