postgres-centos.yaml

postgres:
  use_upstream_repo: True
  version: '9.5'
  pkg: postgresql
  pkgs_extra: []
  pkg_client: postgresql-client
  pkg_dev: postgresql-devel
  pkg_libpq_dev: postgresql-libs
  python: python-psycopg2
  user: postgres
  group: postgres

  prepare_cluster:
    command: initdb --pgdata=/var/lib/pgsql/data
    test: test -f /var/lib/pgsql/data/PG_VERSION
    user: postgres
    env: {}

  conf_dir: /var/lib/pgsql/data
  postgresconf: ""

  pg_hba.conf: salt://postgres/templates/pg_hba.conf.j2
  acls:
    # "local" is for Unix domain socket connections only
    - ['local', 'all', 'all', 'peer']
    # IPv4 local connections:
    - ['host', 'all', 'all', '127.0.0.1/32', 'md5']
    # IPv6 local connections:
    - ['host', 'all', 'all', '::1/128', 'md5']

  config_backup: '.bak'

  service: postgresql

  bake_image: False

  users: {}
  tablespaces: {}
  databases: {}
  schemas: {}
  extensions: {}
  
  pkg_repo:
    name: pgdg95
    humanname: PostgreSQL 9.5 $releasever - $basearch
    baseurl: 'https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-$releasever-$basearch'
    gpgcheck: 1
    gpgkey: 'https://download.postgresql.org/pub/repos/yum/RPM-GPG-KEY-PGDG-9.5'