Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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/",
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement