1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

    postgresql::schema{"/var/lib/pgsql/data/syslog.schema":
        ensure => present,
        database => "syslog",
        user     => "syslog",
        source => "puppet:///modules/syslog-ng/syslog.schema",
        tablematch => "remote_messages",
    }

    #Exec to create first 2 partitions if no partitions exist
    exec { "/var/lib/pgsql/data/create_partition.py | psql -U syslog syslog && /var/lib/pgsql/data/create_partition.py -n | psql -U syslog syslog":
        require => File["/var/lib/pgsql/data/create_partition.py"],
        path    => "/bin:/usr/bin:/usr/local/bin",
        unless  => "echo \"\\d\" | psql -U syslog syslog | grep \"remote_messages.*q\"",
        require => postgresql::schema["/var/lib/pgsql/data/syslog.schema"],
    }