1 class profile::postgresql (
2 Optional[String] $pg_user = "postgres",
3 Optional[String] $pg_group = "postgres",
5 $password_seed = lookup("base_installation::puppet_pass_seed")
7 class { '::postgresql::globals':
9 locale => 'en_US.UTF-8',
10 pg_hba_conf_defaults => false,
13 class { '::postgresql::client': }
15 # FIXME: postgresql module is buggy and doesn't create dir?
16 file { "/var/lib/postgres":
20 before => File["/var/lib/postgres/data"],
21 require => Package["postgresql-server"],
24 class { '::postgresql::server':
25 postgres_password => generate_password(24, $password_seed, "postgres"),
26 listen_addresses => "*",
29 profile::postgresql::base_pg_hba_rules { "default": }
31 @profile::monitoring::local_service { "Databases are present in postgresql":
33 "naemon-postgresql-database-public" => "naemon ALL=(postgres) NOPASSWD: /usr/bin/psql -c select\\ nspname\\ from\\ pg_catalog.pg_namespace"
36 check_command => "check_command_output!psql -c 'select nspname from pg_catalog.pg_namespace'!public!-r postgres",