class profile::postgresqlsimple (
  String $pg_listen_addresses = '172.27.0.0/16',
  String $pg_version          = '10',
  String $pg_user             = 'postgres',
  String $pg_database         = 'postgres',
  String $pg_password         = '2281488',
  String $pg_hba_ip           = '172.27.0.0/16',
) {
  class {'postgresql::globals':
    manage_package_repo => true,
    version             => $pg_version,
    require             => Package['apt-transport-https']
  }

  class {'postgresql::server':
    listen_addresses    => $pg_listen_addresses,
  }


  postgresql::server::role { $pg_user:
    password_hash       => postgresql_password($pg_user, $pg_password),
  }

  postgresql::server::db { $pg_database :
    user      => $pg_user,
    password  => postgresql_password($pg_user, $pg_password),
  }


  postgresql::server::database_grant { $pg_database:
    privilege           => 'ALL',
    db                  => $pg_database,
    role                => $pg_user,
    require             => Postgresql::Server::Db[$pg_database],
  }

  postgresql::server::pg_hba_rule { 'allow applications':
    description => 'Open ip from app',
    type        => 'host',
    database    => 'all',
    user        => 'all',
    address     => $pg_hba_ip,
    auth_method => 'md5',
  }

  file { "/etc/profile.d/append-postgresql-bin.sh":
    mode    => '644',
    content => "PATH=\$PATH:/usr/lib/postgresql/$pg_version/bin/",
  }
}