From a3581df11dfa60a390620719247bee1d1576ea85 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Oliver=20B=C3=B6ttcher?= <oliver.boettcher@pixelpark.com>
Date: Mon, 19 Mar 2018 09:54:45 +0100
Subject: [PATCH] MBVD-VAN: postgres 9.6 upgrade

---
 ...portal-mercedes-benz-de.pixelpark.net.yaml | 32 +++++++++++++++++++
 1 file changed, 32 insertions(+)

diff --git a/customer/mbvd-van-werkstattportal/dev-web-van-werkstattportal-mercedes-benz-de.pixelpark.net.yaml b/customer/mbvd-van-werkstattportal/dev-web-van-werkstattportal-mercedes-benz-de.pixelpark.net.yaml
index 7b75bec9..b5e635d4 100644
--- a/customer/mbvd-van-werkstattportal/dev-web-van-werkstattportal-mercedes-benz-de.pixelpark.net.yaml
+++ b/customer/mbvd-van-werkstattportal/dev-web-van-werkstattportal-mercedes-benz-de.pixelpark.net.yaml
@@ -1,6 +1,7 @@
 ---
 infra::additional_classes:
   - accounts
+  - infra::profile::pg_server
 #  - logstash
 
 #logstash::verbose_run: true
@@ -27,3 +28,34 @@ sudo::configs:
     priority: "06"
     content: |
       jenkins ALL=(wwwrun) NOPASSWD: ALL
+
+infra::profile::pg_server::manage_repo: false
+infra::profile::pg_server::version: '96'
+postgresql::server::contrib::package_ensure: true
+postgresql::server::locale: 'de_DE.UTF-8'
+
+infra::profile::pg_server::pgpw: '%MV#6"!dF.Q7%\q^'
+infra::profile::pg_server::dbs:
+  van:
+    password: V6G5tRe3otMA
+
+infra::profile::pg_server::configs:
+  shared_buffers:
+    value: '1024MB'
+  max_connections:
+    value: '100'
+  work_mem:
+    value: '32MB'
+  dynamic_shared_memory_type:
+    value: 'mmap'
+  shared_preload_libraries:
+    value: 'pg_stat_statements'
+  track_activity_query_size:
+    value: '4096'
+  pg_stat_statements.track:
+    value: 'all'
+
+infra::profile::pg_server::backup::weeks_to_keep: 0
+infra::profile::pg_server::backup::days_to_keep: 2
+infra::profile::pg_server::backup::day_of_week_to_keep: 0
+infra::profile::pg_server::backup::enable_plain_backups: false
-- 
2.39.5