PG_RedHat.yml

---
# Variables for EPAS
pg_port: "5432"
pg_owner: "postgres"
pg_user_home: "/var/lib/pgsql"
pg_service: "{{ lookup('edb_devops.edb_postgres.pg_service') }}"
pg_database: "postgres"
pg_unix_socket_directories:
  - "/var/run/postgresql"

shell_profile_path: "{{ pg_user_home }}/.pgsql_profile"
shell_profile_owner: "postgres"
shell_profile_group: "postgres"
shell_profile_mode: "0600"
shell_profile_content: |
  # PostgreSQL shell environment
  export PGDATA={{ pg_data }}
  export PGDATABASE=postgres
  export PGUSER=postgres
  export PGPORT={{ pg_port }}
  export PGLOCALEDIR=/usr/pgsql-{{ pg_version }}/share/locale
  export PGHOST={{ pg_unix_socket_directories[0] }}

psqlrc_path: "{{ pg_user_home }}/.psqlrc"
psqlrc_owner: "postgres"
psqlrc_group: "postgres"
psqlrc_mode: "0600"
psqlrc_content: |
  -- psql configuration

pg_data: "{{ pg_user_home }}/{{ pg_version }}/data"