We always get asked about how to backup PuppetDB, we probably should write a formal doc.
From notes after discussion with @glarizza, the following could be used for Postgres:
(be mindful this will not backup/restore the `puppetdb` user)
But that doesn't help our HSQLDB users.
puppetdb-export is also a possibility, but requires more explanation for the restore.
Even if the document is vague and tries to refer users to vendor documentation - we should try to explain what data is important, how hot parts are - what matters and what can be recreated with a simple puppet run on all nodes (in the worst case).