postgresql/manifests/init.pp

class postgresql {
    
    $pgsql_data = "/var/lib/pgsql/data/"

    package { 'postgresql9.0-server':
        alias => "postgresql-server",
        ensure => installed
    }

    service { postgresql:
        ensure => running,
        subscribe => Package["postgresql-server"],
        hasstatus => true,
    }

    exec { "service postgresql reload":
        refreshonly => true,
        subscribe => [ File["postgresql.conf"], 
                       File["pg_ident.conf"],
                       File["pg_hba.conf"] ]
    }

    file { '/etc/pam.d/postgresql':
        ensure => present,
        owner  => root,
        group  => root,
        mode   => 644,
        content => template("postgresql/pam"),
    }

    file { "postgresql.conf":
        path => "$pgsql_data/postgresql.conf",
        ensure => present,
        owner => postgres,
        group => postgres,
        mode => 600,
        content => template("postgresql/postgresql.conf"),
        require => Package["postgresql-server"],
    }
    
    file { 'pg_hba.conf':
        path => "$pgsql_data/pg_hba.conf",
        ensure => present,
        owner => postgres,
        group => postgres,
        mode => 600,
        content => template("postgresql/pg_hba.conf"),
        require => Package["postgresql-server"],
    }

    file { 'pg_ident.conf':
        path => "$pgsql_data/pg_ident.conf",
        ensure => present,
        owner => postgres,
        group => postgres,
        mode => 600,
        content => template("postgresql/pg_ident.conf"),
        require => Package["postgresql-server"],
    }
}
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	misc	190	path => "$pgsql_data/postgresql.conf",
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	misc	190	path => "$pgsql_data/pg_hba.conf",
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	misc	190	path => "$pgsql_data/pg_ident.conf",
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	}