ensure postgres permissions are correct

1 files changed, 12 insertions, 1 deletions

diff --git a/modules/postgres/manifests/init.pp b/modules/postgres/manifests/init.pp
index 3ac9887..890c81a 100644
--- a/modules/postgres/manifests/init.pp
+++ b/modules/postgres/manifests/init.pp
@@ -4,7 +4,8 @@ class postgres {
   $dbpath = "${persistent_data}/postgres" # lint:ignore:variable_scope
 
   package { "postgresql":
-      ensure => installed;
+      ensure => installed,
+      notify => Exec["fixup db path permissions"];
   }
 
   file {
@@ -29,6 +30,16 @@ class postgres {
       require => File["/etc/systemd/system/postgresql.service.d"];
   }
 
+  exec { "fixup db path permissions":
+    command => "chown -R postgres:postgres ${dbpath}",
+    refreshonly => true,
+    require => [
+      Package['postgresql'],
+      File[$dbpath],
+    ],
+    before => Service['postgresql'];
+  }
+
   exec { "initialize db path":
     command => "/usr/bin/initdb -D $dbpath/data",
     user => 'postgres',