Puppet file for generating pg_dump cron

postgres-backup.pp

# Define: postgresql::backup
#
# Backup of a postgresql database using pgdump.
# Usage: postgresql::backup { [ 'db1', 'db2' ]: }
define postgresql::backup {
  file{ [ '/backups', '/backups/postgres', "/backups/postgres/${title}" ]:
    ensure  => 'directory',
    owner   => 'postgres'
  }

  cron{ "${title}-pg-dump":
    command => "/usr/bin/pg_dump ${title} | gzip -c -9 > /backups/postgres/${title}/`date +%Y-%m-%d`.sql.gz",
    user    => 'postgres',
    hour    => '0-23/4',
    minute  => 40,
    require => File["/backups/postgres/${title}"]
  }
}