sc_postgresql

Table of Contents

1. Overview
2. Module Description - What the module does and why it is useful
3. Setup - The basics of getting started with sc_apache
   • What sc_apache affects
   • Beginning with sc_apache
4. Usage - Configuration options and additional functionality
5. Local Testing

Overview

ScaleCommerce Wrapper Module for puppetlabs-postgresql. Manages Supervisord, Databases, Users, Roles.

Module Description

This module uses hiera to configure Postgresql ressources.

Setup

What sc_postgresql affects

• postgresql
• supervisord

Beginning with sc_postgresql

You will need a working hiera-Setup (https://docs.puppetlabs.com/hiera/3.1/complete_example.html).

Check out our solultion for Puppet-Hiera-Roles (https://github.com/ScaleCommerce/puppet-hiera-roles).

Usage: Databases

Put this into your node.yaml or role.yaml. See Documentation of puppetlabs-postgresql for details on params and syntax.

---
classes:
  - sc_postgresql

  sc_postgresql::databases:
    shop:
      user: spryker
      owner: spryker
      password: very_secret_password!!

Testing

When making changes you can test this module locally with gitlab-runner on Mac OSX

gitlab-runner exec docker --env "GIT_STRATEGY=none" --docker-volumes `pwd`:/builds/project-0 xenial:puppet5