puppetlabs/postgresql + puppetlabs/puppetdb with PostgreSQL 9.5 from SoftwareCollections on CentOS7

postgresql-service-validate_db_connection.patch

--- a/manifests/server/service.pp     2017-04-10 13:29:34.307586169 +0200
+++ b/manifests/server/service.pp  2017-04-10 13:28:03.756056508 +0200
@@ -9,6 +9,7 @@
   $user             = $postgresql::server::user
   $port             = $postgresql::server::port
   $default_database = $postgresql::server::default_database
+  $connect_settings = $postgresql::server::default_connect_settings
 
   anchor { 'postgresql::server::service::begin': }
 
@@ -33,6 +34,7 @@
         run_as          => $user,
         database_name   => $default_database,
         database_port   => $port,
+        connect_settings => $connect_settings,
         sleep           => 1,
         tries           => 60,
         create_db_first => false,

puppetdb-postgresql-9.5-example.pp

class { '::postgresql::globals':
  version => '9.5',
  bindir => '/opt/rh/rh-postgresql95/root/usr/bin',
  service_name => 'rh-postgresql95-postgresql',
  server_package_name => 'rh-postgresql95-postgresql-server',
  client_package_name => 'rh-postgresql95-postgresql',
  contrib_package_name => 'rh-postgresql95-postgresql-contrib',
  devel_package_name => 'rh-postgresql95-postgresql-devel',
  docs_package_name => 'rh-postgresql95-postgresql-docs',
  plperl_package_name => 'rh-postgresql95-postgresql-plperl',
  plpython_package_name => 'rh-postgresql95-postgresql-plpython',
  default_connect_settings => {
    'LD_LIBRARY_PATH' => '/opt/rh/rh-postgresql95/root/usr/lib64',
  }
}
 
class { '::postgresql::server':
  ip_mask_allow_all_users => '0.0.0.0/0',
  listen_addresses        => '127.0.0.1',
}
 
class { '::postgresql::server::contrib': }
 
postgresql::server::extension { 'pg_trgm':
  database  => 'puppetdb',
}
 
class { 'puppetdb':
  disable_ssl => true,
  manage_firewall => false,
  manage_dbserver => false,
}