overstate.sls

mine_interfaces:
  match: '*'
  function:
    mine.send:
      - network.interfaces

db:
  match: '*db*'
  require:
    - mine_interfaces
  sls:
    - postgresql.project
    - postgresql.ufw

app:
  match: '*web*'
  require:
    - db
  sls:
    - pgbouncer

pgbouncer.ini

; hiii
{% for host, ifaces in salt['mine.get']('{{ target }}', 'network.interfaces').iteritems() %}
{% set host_addr = ifaces.get('{{ interface }}', {}).get('inet', [{}])[0].get('address') %}
{{ pillar['project_name'] }}_{{ pillar['environment'] }} = host={{ address }}
{% endfor %}

pgbouncer.sls

postgresql-client:
  pkg:
    - installed

pgbouncer:
  pkg:
    - installed
    - require:
      - pkg: postgresql-client
  service:
    - running
    - enable: True

pgbouncer_ini:
  file.managed:
    - name: /etc/pgbouncer/pgbouncer.ini
    - source: salt://pgbouncer/pgbouncer.ini
    - user: root
    - group: root
    - mode: 0640
    - template: jinja
    - context:
      target: '*db*'
      interface: pillar['primary_iface']
    - require:
      - pkg: pgbouncer