Using Modules PostgreSQL - mcuyar/station GitHub Wiki

The PostgreSQL module will allow to manage databases and database users. The PostgreSQL module can be added as a global parameter or a site parameter.

Install Postgres Contrib

Postgres contrib is set to install by default, which adds features such as hstore, json, etc... datastores.

postgresql:
  contrib:
    install: true
    version: 9.3

To create a database or user supply the postgresql parameter to your config file as an array

Add a Database

postgresql:
 databases:
   - name: station # database name
     drop: false # set to true to create new database on each provision

Add a User

postgresql:
  databases: 
    - user: station
      password: station

Add a Database and User

postgresql:
  databases:
    - name: station
      drop: false
      user: station
      password: station