Uploaded image for project: 'PuppetDB'
  1. PuppetDB
  2. PDB-182

Document backup and restoration advice

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Normal
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: DOCS
    • Labels:
    • Template:
    • Story Points:
      2

      Description

      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:

      pg_dump -Z 9 -Fc puppetdb > /tmp/backup.dump
      pg_restore -c --jobs=2 -Fc -d puppetdb /tmp/backup.dump
      

      (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).

        Attachments

          Activity

            People

            • Assignee:
              mike.hall Mike Hall
              Reporter:
              redmine.exporter redmine.exporter
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Zendesk Support