1 

     2 class sysconfig::postgresql (

     3     $db_host    = hiera('sysconfig::params::db_host', $sysconfig::params::db_host),

     4     $db_port    = hiera('sysconfig::params::db_port', $sysconfig::params::db_port),

     5     $db_name    = hiera('sysconfig::params::db_name', $sysconfig::params::db_name),

     6     $db_user    = hiera('sysconfig::params::db_user', $sysconfig::params::db_user),

     7     $db_pw      = hiera('sysconfig::params::db_pw', $sysconfig::params::db_pw),

     8 ) inherits sysconfig::params {

     9 

    10     notify {'postgresql': name => "\$db_host : ${db_host}, \$db_port : ${db_port}, \$db_name : ${db_name}, \$db_user : ${db_user}, \$db_pw : ${db_pw}", withpath => true }

    11 

    12     if $sysconfig::params::db_is_local {

    13         class { 'postgresql::server': }

    14 

    15         postgresql::server::db { $db_name:

    16             user     => $db_user,

    17             password => postgresql_password($db_user, $db_pw),

    18             encoding => 'UTF8',

    19         }

    20     }

    21     else {

    22         class { 'postgresql::client': }->

    23         postgresql::validate_db_connection { 'validate_postgres_connection':

    24             database_host           => $db_host,

    25             database_port           => $db_port,

    26             database_username       => $db_user,

    27             database_password       => $db_pw,

    28             database_name           => $db_name,

    29         }

    30     }

    31 }