From b57f2101d55a12e2e918304bdbdc0986b0900536 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Oliver=20B=C3=B6ttcher?= Date: Fri, 20 Jan 2017 12:45:06 +0100 Subject: [PATCH] ODT - enable pg_stat_statements --- .../mbvd-odt/dev-cms-emmt-daimler-com.pixelpark.net.yaml | 5 ++--- customer/mbvd-odt/dev-odt-daimler-com.pixelpark.net.yaml | 3 ++- customer/mbvd-odt/int-db-odt-daimler-com.pixelpark.net.yaml | 6 ++---- 3 files changed, 6 insertions(+), 8 deletions(-) diff --git a/customer/mbvd-odt/dev-cms-emmt-daimler-com.pixelpark.net.yaml b/customer/mbvd-odt/dev-cms-emmt-daimler-com.pixelpark.net.yaml index 5f3f8302..5a466737 100644 --- a/customer/mbvd-odt/dev-cms-emmt-daimler-com.pixelpark.net.yaml +++ b/customer/mbvd-odt/dev-cms-emmt-daimler-com.pixelpark.net.yaml @@ -9,9 +9,6 @@ site::profile::pg_server::version: '9.6' postgresql::server::contrib::package_ensure: true postgresql::repo::baseurl: 'http://repo.pixelpark.com/Linux/yum/pgsql/9.6/redhat/rhel-$releasever-$basearch' -postgresql::server::config_entry: - shared_preload_libraries: 'pg_stat_statements' - site::profile::pg_server::pgpw: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAkugNwUWX4P8vxOp89U+URzSgghBbbyopCiHdprHb68x8eRDn7ubDvOn2f9pkJ2Sf5kndGep/hBWS3kcxzFjvBjAN1hRR77F7yVDcOkr5argryxPBwIgokE1e1DQev2NeJ3I/hwrNZXQJeMwByJPL3wDJUh8FBIvCNmlg364uRrGNlVlOdDnd0KVA9D3RNq5ktllGRrmQVNvWFQHAkSP2DGBmLMgZDzO5Xu9bLbBmZ1zJjyXPXKHVU2UAMdNMG68ttIiD/e2FuXCmetTJKW34ryhi1eYek5Qa2biNW5Mr0pDoSFm4FH+6Hx5FZUUOPai++hxXJKYdm67ImiyP2onwUTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDcskAPEhYhdqSsEaOarS6BgCAVeAxlgbuL8jeKINtiYpoE0DTbAyUPSlGJmD+wfTe+1Q==] site::profile::pg_server::dbs: opencms: @@ -26,6 +23,8 @@ site::profile::pg_server::configs: value: '4MB' dynamic_shared_memory_type: value: 'mmap' + shared_preload_libraries: + value: 'pg_stat_statements' site::profile::pg_server::backup::weeks_to_keep: 0 site::profile::pg_server::backup::days_to_keep: 2 diff --git a/customer/mbvd-odt/dev-odt-daimler-com.pixelpark.net.yaml b/customer/mbvd-odt/dev-odt-daimler-com.pixelpark.net.yaml index 94a181ec..04379ed8 100644 --- a/customer/mbvd-odt/dev-odt-daimler-com.pixelpark.net.yaml +++ b/customer/mbvd-odt/dev-odt-daimler-com.pixelpark.net.yaml @@ -21,7 +21,6 @@ postgresql::server::ipv4acls: postgresql::repo::baseurl: 'http://repo.pixelpark.com/Linux/yum/pgsql/9.6/redhat/rhel-$releasever-$basearch' postgresql::server::config_entry: - shared_preload_libraries: 'pg_stat_statements' site::profile::pg_server::pgpw: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAZQoHfKAzxvzHW4cYR1VBfTIw4HKzCQMBmaAkToHo9kJuht/dP0FAKArNRSok3IL7WO6gyyE00VY04gt4s3OtqOLkPd1cQ1b+SUWGvgSYUpggYz6D/0eLQSUQ2uBouBR9jS0B9yWjoN2Qru4JCynjG5mShBYwB1Tz6ESXuTJOIkrsJx0KJf+rJ28sWysLYkJTvUHJ46kYyd8JV62/ncnNxikcAQoZpxraDFk+xt+Rq4LVIKkzdzfFX00Gpb87uEAyfQNCuStPvRv16501azo0ojdsdjFPY9xnPiWnbuhyl+hY9unNIa7aupd8b4EAUrl/Os/1ikJrVIGyWwnql6+GATBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBD77URKcuc8FkVIn/WQA6F9gCAQRm6uUSeMDdeQSle4f/LEmffAxJF3eQWgwdMgBq6hUw==] site::profile::pg_server::dbs: @@ -37,6 +36,8 @@ site::profile::pg_server::configs: value: '4MB' dynamic_shared_memory_type: value: 'mmap' + shared_preload_libraries: + value: 'pg_stat_statements' site::profile::pg_server::backup::weeks_to_keep: 0 site::profile::pg_server::backup::days_to_keep: 2 diff --git a/customer/mbvd-odt/int-db-odt-daimler-com.pixelpark.net.yaml b/customer/mbvd-odt/int-db-odt-daimler-com.pixelpark.net.yaml index cd4a801e..4214afa6 100644 --- a/customer/mbvd-odt/int-db-odt-daimler-com.pixelpark.net.yaml +++ b/customer/mbvd-odt/int-db-odt-daimler-com.pixelpark.net.yaml @@ -15,10 +15,6 @@ postgresql::server::ipv4acls: - 'host openemm_cms openemm 93.188.107.233/32 md5' postgresql::repo::baseurl: 'http://repo.pixelpark.com/Linux/yum/pgsql/9.6/redhat/rhel-$releasever-$basearch' -postgresql::server::config_entry: - shared_preload_libraries: 'pg_stat_statements' - - site::profile::pg_server::pgpw: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAQgpDTDusJsmMYdACOwKPfEhZbLU+Tynjnm7fBDH+KTS9cPCoCQ4E9TZgHEwy3wNv+nMbUsoSZY/xFHoF/JgPlV0cZLtsJ2WLJZC5SLIoL0JEvOlUIMgbSnxwKJ72zKUf6qJnuCDz0rJ7LavwQvf3D/lmBo2rXP5wuQfyxeSr0aO7JsO7f58VUMRigLZ/JvOAmvMycbtVaSd3n+TYoKCRlomzdFeZkC6DTVMWIiuVuhRG05XL5rkSdO+EUMi0ohZ2LKKBqJHL5tATDK9QRSllKSoix5Y3jhye1LFHDZJm1w2BRX7n107v1sjsI9lax5gDsiMIfbsNv0aBGxMUcht7uzBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBFb2Q2Qy9+9O4bZAQTb1OzgCDAwTXbSFnPfdRaWlI3R734TM0APzt2EvIExutplW942Q==] site::profile::pg_server::dbs: openemm: @@ -37,6 +33,8 @@ site::profile::pg_server::configs: value: '16MB' dynamic_shared_memory_type: value: 'mmap' + shared_preload_libraries: + value: 'pg_stat_statements' site::profile::pg_server::backup::weeks_to_keep: 0 site::profile::pg_server::backup::days_to_keep: 2 -- 2.39.5