Postgres Blueprint¶

Fabric environment:

blueprints:
  - blues.postgres

settings:
  postgres:
    version: 9.3           # PostgreSQL version (required)
    schemas:
      some_schema_name:    # The schema name
        user: foo          # Username to connect to schema
        password: bar      # Password to connect to schema (optional)

setup¶: Install, configure Postgresql and create schemas

configure¶: Configure Postgresql

setup_schemas¶

Create database schemas and grant user privileges

Parameters:	drop – Drop existing schemas before creation

generate_pgtune_conf¶

Run pgtune and create pgtune.conf

Parameters:	role – Which fabric role to place local pgtune.conf template under

dump¶

Dump and download all configured, or given, schemas.

Parameters:	schema – Specific shema to dump and download.