postgresql

pdk
Setup postgresql

Puppet-Finland team

puppetfinland

6,061 downloads

5,295 latest version

5.0 quality score

Version information

  • 1.0.4 (latest)
  • 1.0.3
  • 1.0.2
  • 1.0.1
released May 18th 2018
This version is compatible with:
  • Puppet Enterprise 2018.1.x, 2017.3.x, 2017.2.x, 2017.1.x, 2016.5.x, 2016.4.x
  • Puppet >= 4.7.0 < 6.0.0
  • Ubuntu

Start using this module

Documentation

puppetfinland/postgresql — version 1.0.4 May 18th 2018

postgresql

A Puppet module for managing postgresql servers and configuring database dumps. Reuses providers from puppetlabs-postgresql. Includes optional firewall and monit support.

Module usage

Setup latest postgresql version from the project's repositories:

class { '::postgresql':
  use_latest_release => true,
}

Configure a backup job with default settings:

postgresql::backup { 'my_database_name': }

Customize backup schedule:

postgresql::backup { 'my_database_name':
  hour    => 4,
  minute  => 45,
  weekday => *',
}

The $pg_dump_extra_params parameter can be used to customize the backup job further.

To load an SQL file (generally from another module):

postgresql::loadsql { 'bacula-bacula-director.sql':
  modulename => 'bacula',
  basename   => 'bacula-director',
}

For details see init.pp, backup.pp and loadsql.pp

Usage instructions for the bundled types and providers is here:

License

Most classes and defines are licensed under the BSD license (see file LICENSE.BSD). The types, providers and classes included from postgresql::softwarerepo class have been taken from puppetlabs-postgresql (HEAD at 0ffbcc0). These files are thus covered by the Apache 2.0 license (see file LICENSE.APACHE).