postgresql/manifests/init.pp

class postgresql {
    package { 'postgresql9.0-server':
        ensure => installed
    }

    service { postgresql:
        ensure => running,
        subscribe => Package["postgresql9.0-server"],
        restart => "/etc/rc.d/init.d/postgresql reload"
    }

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

    file { '/var/lib/pgsql/data/postgresql.conf':
        ensure => present,
        owner => postgres,
        group => postgres,
        mode => 600,
        content => template("postgresql/postgresql.conf"),
        require => Package["postgresql9.0-server"],
        notify => [Service["postgresql"]]
    }
    
    file { '/var/lib/pgsql/data/pg_hba.conf':
        ensure => present,
        owner => postgres,
        group => postgres,
        mode => 600,
        content => template("postgresql/pg_hba.conf"),
        require => Package["postgresql9.0-server"],
        notify => [Service["postgresql"]]
    }
}
1	class postgresql {
2	package { 'postgresql9.0-server':
3	ensure => installed
4	}
5
6	service { postgresql:
7	ensure => running,
8	subscribe => Package["postgresql9.0-server"],
9	restart => "/etc/rc.d/init.d/postgresql reload"
10	}
11
12	file { '/etc/pam.d/postgresql':
13	ensure => present,
14	owner => root,
15	group => root,
16	mode => 644,
17	content => template("postgresql/pam"),
18	}
19
20	file { '/var/lib/pgsql/data/postgresql.conf':
21	ensure => present,
22	owner => postgres,
23	group => postgres,
24	mode => 600,
25	content => template("postgresql/postgresql.conf"),
26	require => Package["postgresql9.0-server"],
27	notify => [Service["postgresql"]]
28	}
29
30	file { '/var/lib/pgsql/data/pg_hba.conf':
31	ensure => present,
32	owner => postgres,
33	group => postgres,
34	mode => 600,
35	content => template("postgresql/pg_hba.conf"),
36	require => Package["postgresql9.0-server"],
37	notify => [Service["postgresql"]]
38	}
39	}