Skip to content


Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Puppet PostgreSQL module
branch: master

Merge pull request #36 from rjsmelo/fix_encoding_quotes

Fixed the encoding quotes to single quotes since it is a string constant
latest commit b8d5281569
Alessandro Franceschi alvagante authored

Puppet module: postgresql

This is a Puppet module for postgresql based on the second generation layout ("NextGen") of Example42 Puppet Modules.

Made by Alessandro Franceschi / Lab42

Official site:

Official git repository:

Released under the terms of Apache 2 License.

This module requires functions provided by the Example42 Puppi module (you need it even if you don't use and install Puppi)

For detailed info about the logic and usage patterns of Example42 modules check the DOCS directory on Example42 main modules set.

USAGE - Basic management

  • Install postgresql with default settings

    class { 'postgresql': }
  • Install a specific version of postgresql package

    class { 'postgresql':
      version => '1.0.1',
  • Disable postgresql service.

    class { 'postgresql':
      disable => true
  • Remove postgresql package

    class { 'postgresql':
      absent => true
  • Enable auditing without without making changes on existing postgresql configuration files

    class { 'postgresql':
      audit_only => true

USAGE - Overrides and Customizations

  • Use custom sources for main config file

    class { 'postgresql':
      source => [ "puppet:///modules/lab42/postgresql/postgresql.conf-${hostname}" , "puppet:///modules/lab42/postgresql/postgresql.conf" ], 
  • Use custom source directory for the whole configuration dir

    class { 'postgresql':
      source_dir       => 'puppet:///modules/lab42/postgresql/conf/',
      source_dir_purge => false, # Set to true to purge any existing file not present in $source_dir
  • Use custom template for main config file. Note that template and source arguments are alternative.

    class { 'postgresql':
      template => 'example42/postgresql/postgresql.conf.erb',
  • Automatically include a custom subclass

    class { 'postgresql':
      my_class => 'postgresql::example42',

USAGE - Example42 extensions management

  • Activate puppi (recommended, but disabled by default)

    class { 'postgresql':
      puppi    => true,
  • Activate puppi and use a custom puppi_helper template (to be provided separately with a puppi::helper define ) to customize the output of puppi commands

    class { 'postgresql':
      puppi        => true,
      puppi_helper => 'myhelper', 
  • Activate automatic monitoring (recommended, but disabled by default). This option requires the usage of Example42 monitor and relevant monitor tools modules

    class { 'postgresql':
      monitor      => true,
      monitor_tool => [ 'nagios' , 'monit' , 'munin' ],
  • Activate automatic firewalling. This option requires the usage of Example42 firewall and relevant firewall tools modules

    class { 'postgresql':       
      firewall      => true,
      firewall_tool => 'iptables',
      firewall_src  => '',
      firewall_dst  => $ipaddress_eth0,

Build Status

Something went wrong with that request. Please try again.