postgres puppet module snippit

postgres puppet

# puppet module install puppetlabs/postgresql
class { 'postgresql::server':
  config_hash => {
    'ip_mask_deny_postgres_user' => '0.0.0.0/32',
    'ip_mask_allow_all_users'    => '0.0.0.0/0',
    'ipv4acls'                   => ['host all all 127.0.0.1/32 md5 '],
    'listen_addresses'           => '*',
    'manage_pg_hba_conf'         => true,
  },
}



postgresql::database_user {'xx':
  password_hash => 'xxxx'
}

postgresql::db { 'xxxx':
  user     => 'xxxx',
  password => 'xxxx'
}