pillar_novaauth_db.sls

postgresql-database:
    nova:
        user: novaauth
        password: novaauth
        name: novaauth

pillar_peopleask_db.sls

postgresql-databases:
    peopleaask:
            user: peopleask
            password: peopleask
            name: peopleask

pillar_top.sls

base:
  'roles:peopleask':
    - match: grain
    - peopleask.db

  'roles:novaauth':
    - match: grain
    - novaauth.db

salt_postgresql.sls

postgresql:
    pkg:
        - name: postgresql-9.1
        - installed
    service.running:
        - enable: True

postgresql_db_{{ pillar['postgresql_db_name'] }}:
    postgres_database.present:
        - name: {{ pillar['postgresql_db_name'] }}
        - owner: {{ pillar['postgresql_db_user'] }}
        - encoding: UTF8
        - lc_ctype: en_US.UTF8
        - lc_collate: en_US.UTF8
        - template: template0
        - runas: postgres
        - require:
            - service: postgresql
            - postgres_user: postgresql_user_{{ pillar['postgresql_db_user'] }}

postgresql_user_{{ pillar['postgresql_db_user'] }}:
    postgres_user.present:
        - name: {{ pillar['postgresql_db_user'] }}
        - password: {{ pillar['postgresql_db_password'] }}
        - require:
            - service: postgresql

postgresql.conf:
    file.append:
        - name: /etc/postgresql/9.1/main/postgresql.conf
        - text: "listen_addresses = '*'"
        - require:
            - pkg: postgresql
        - watch_in:
            - service: postgresql

salt_top.sls

base:
  'G@roles:peopleask and G@roles:postgresql':
    - match: compound
    - postgresql

  'G@roles:novaauth and G@roles:postgresql':
    - match: compound
    - postgresql