From fe3d2db3d7e942f987fa3b4bdc44efd7cc802ef2 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Hugo=20H=C3=B6rnquist?= <hugo@lysator.liu.se>
Date: Fri, 21 Jan 2022 11:51:05 +0100
Subject: Puppetdb dump database every 30 min.

---
 manifests/puppetdb.pp | 13 +++++++++++++
 1 file changed, 13 insertions(+)

diff --git a/manifests/puppetdb.pp b/manifests/puppetdb.pp
index b321433..3f8ca0b 100644
--- a/manifests/puppetdb.pp
+++ b/manifests/puppetdb.pp
@@ -18,4 +18,17 @@ class profiles::puppetdb {
     # profiles::puppetserver is also pulled in.
     create_puppet_service_resource => false,
   }
+
+  file { '/var/tmp/pg_dump':
+    ensure => directory,
+    owner  => 'postgres',
+  }
+
+  cron { 'dump database':
+    ensure  => present,
+    command => 'pg_dump puppetdb > /var/tmp/pg_dump/puppetdb-$(date -u -Iseconds).sql',
+    user    => 'postgres',
+    hour    => '*',
+    minute  => '30',
+  }
 }
-- 
cgit v1.2.3