postgres_everything:
  pkg.installed:
    - names:
      - postgresql91-client
      - postgresql91-contrib
      - postgresql91-plperl
      - postgresql91-server

kern.ipc.shmmax:
  sysctl.present:
    - value: 536870912

kern.ipc.shmall:
  sysctl.present:
    - value: 131072

initialdatabase:
  cmd.run:
    - name: /usr/local/etc/rc.d/postgresql oneinitdb
    - unless: '[ -f /usr/local/pgsql/data/postgresql.conf ]'
    - require:
      - pkg: postgres_everything

postgresql:
  service:
    - running
    - watch:
      - cmd: initialdatabase
      - pkg: postgres_everything

databaseglobals:
  cmd.run:
    - name: |
        ssh maayan.insightcruises.com pg_dumpall -g | psql -U pgsql template1
        touch /usr/local/pgsql/data/SALT-GLOBALS-LOADED
    - unless: '[ -f /usr/local/pgsql/data/SALT-GLOBALS-LOADED ]'
    - require:
      - service: postgresql