We Shall See

---
- name: add postgresql repository
  apt_repository:
    repo: "deb http://apt.postgresql.org/pub/repos/apt/ {{ ansible_lsb.codename }}-pgdg main 9.4"
- name: import postgres repository signing key
  register: repo_key
  apt_key:
    url: http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc
- name: update apt cache
  when: repo_key.changed
  apt:
    update_cache: yes
- name: install postgres client
  apt:
    name: postgresql-client-9.4
- name: tempate .pgpass file
  sudo_user: ubuntu
  template:
    src: .pgpass
    dest: /home/ubuntu/.pgpass
    mode: 0600

{{ id }}.cliprqr4ifrx.us-east-1.rds.amazonaws.com:5432:postgres:postgres:{{ db.admin_pass }}
{{ id }}.cliprqr4ifrx.us-east-1.rds.amazonaws.com:5432:hipdb:hipuser:{{ db.pass }}