1 |
nanardon |
55 |
class postgresql { |
2 |
misc |
189 |
|
3 |
|
|
$pgsql_data = "/var/lib/pgsql/data/" |
4 |
|
|
|
5 |
nanardon |
57 |
package { 'postgresql9.0-server': |
6 |
misc |
189 |
alias => "postgresql-server", |
7 |
nanardon |
55 |
ensure => installed |
8 |
|
|
} |
9 |
|
|
|
10 |
|
|
service { postgresql: |
11 |
nanardon |
66 |
ensure => running, |
12 |
misc |
189 |
subscribe => Package["postgresql-server"], |
13 |
misc |
120 |
hasstatus => true, |
14 |
nanardon |
55 |
} |
15 |
|
|
|
16 |
misc |
189 |
exec { "service postgresql reload": |
17 |
|
|
refreshonly => true, |
18 |
|
|
subscribe => [ File["postgresql.conf"], |
19 |
|
|
File["pg_ident.conf"], |
20 |
|
|
File["pg_hba.conf"] ] |
21 |
|
|
} |
22 |
|
|
|
23 |
nanardon |
60 |
file { '/etc/pam.d/postgresql': |
24 |
|
|
ensure => present, |
25 |
|
|
owner => root, |
26 |
|
|
group => root, |
27 |
|
|
mode => 644, |
28 |
|
|
content => template("postgresql/pam"), |
29 |
|
|
} |
30 |
|
|
|
31 |
misc |
189 |
file { "postgresql.conf": |
32 |
|
|
path => "$pgsql_data/$name", |
33 |
nanardon |
55 |
ensure => present, |
34 |
|
|
owner => postgres, |
35 |
|
|
group => postgres, |
36 |
nanardon |
60 |
mode => 600, |
37 |
nanardon |
58 |
content => template("postgresql/postgresql.conf"), |
38 |
misc |
189 |
require => Package["postgresql-server"], |
39 |
nanardon |
55 |
} |
40 |
|
|
|
41 |
misc |
189 |
file { 'pg_hba.conf': |
42 |
|
|
path => "$pgsql_data/$name", |
43 |
nanardon |
55 |
ensure => present, |
44 |
|
|
owner => postgres, |
45 |
|
|
group => postgres, |
46 |
nanardon |
60 |
mode => 600, |
47 |
nanardon |
58 |
content => template("postgresql/pg_hba.conf"), |
48 |
misc |
189 |
require => Package["postgresql-server"], |
49 |
nanardon |
55 |
} |
50 |
nanardon |
172 |
|
51 |
misc |
189 |
file { 'pg_ident.conf': |
52 |
|
|
path => "$pgsql_data/$name", |
53 |
nanardon |
172 |
ensure => present, |
54 |
|
|
owner => postgres, |
55 |
|
|
group => postgres, |
56 |
|
|
mode => 600, |
57 |
|
|
content => template("postgresql/pg_ident.conf"), |
58 |
misc |
189 |
require => Package["postgresql-server"], |
59 |
nanardon |
172 |
} |
60 |
nanardon |
55 |
} |