Postgres role loads data into postgres database

[lenards]

Right now, the task that uses psql just uses -f without indicating the target database. This means the default database for the user is the target (and, for postgres user that is postgres database).

- name: run troposphere sql script for postgresql
  become: yes
  become_user: postgres
  command: psql -f {{ POSTGRES_SQL_INSTALL_DIRECTORY }}/{{ TROPOSPHERE_DATABASE_FILE_TO_BE_LOADED | basename }}
  when: LOAD_TROPOSPHERE_DATABASE
  register: output

source: troposphere-setup-troposphere/tasks/main.yml

ℹ️ This will be corrected in a forthcoming pull request that I am authoring.

[lenards]

This is fixed with #30 & #31 (plus some commits I made to master tonight).