Forge Home


Setup postgresql


6,443 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

Start using this module

  • r10k or Code Manager
  • Bolt
  • Manual installation
  • Direct download

Add this module to your Puppetfile:

mod 'puppetfinland-postgresql', '1.0.4'
Learn more about managing modules with a Puppetfile

Add this module to your Bolt project:

bolt module add puppetfinland-postgresql
Learn more about using this module with an existing project

Manually install this module globally with Puppet module tool:

puppet module install puppetfinland-postgresql --version 1.0.4

Direct download is not typically how you would use a Puppet module to manage your infrastructure, but you may want to download the module in order to inspect the code.



puppetfinland/postgresql — version 1.0.4 May 18th 2018


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:


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).