Process

ANSIBLE_LIBRARY=<path to Ansible4IOM>/modules/ ANSIBLE_ROLES_PATH=<path to Ansible4IOM>/roles/ ansible-playbook -i <path to inventory file>/inventory <path to Ansible4IOM>/processes/setup_pgserver.yml

Steps

The process consists of the following steps:

1. pgrepo_install
   1. Install PostgreSQL repository.
2. pgclient_install
   1. Install PG client yum package.
3. pgserver_install
   1. Stop/disable PostgreSQL service.
   2. Install yum packages.
   3. Initialize PostgreSQL server.
4. pgserver_configure
   1. Stop/disable PostgreSQL service.
   2. Install initial pg_hba.conf in order to allow setting superusers password.
   3. Set default values in postgresql.conf.
   4. Start/enable service (wait for DB to get ready).
   5. Update superusers password.
   6. Install productive pg_hba.conf in order to restrict access as much as possible.
   7. Run post_pgserver_configuration_hook.
   8. Restart service to apply changes.

Background Information

The process setup_pgserver installs a PostgreSQL server. Primarily the process is controlled by variables defined in roles/pgserver_config/defaults. Please have a look into the according file to get information about which variables are available.

Additionally, the process setup_pgserver executes hook post_pgserver_configuration_hook, which allows custom configuration changes of PostgreSQL-server besides predefined variables.

To use a server installed this way, a database account suitable for IOM has to be created. The creation of the account is covered by Process - Setup or Reconfigure Database Account.

Examples

Use a Custom Data Directory

The data directory is defined by variable PGSERVER_DATA at roles/pgserver_config/defaults. Add this variable to the inventory and give it a new value. Also see Concept - Ansible4IOM Server Configuration Management 1.0 - 1.1.

...
[all:vars]
PGSERVER_DATA="/ha-raid/pg-data"
...

Now the process setup_pgserver can be executed.

ANSIBLE_LIBRARY=<path to Ansible4IOM>/modules/ ANSIBLE_ROLES_PATH=<path to Ansible4IOM>/roles/ ansible-playbook -i <path to inventory file> <path to Ansible4IOM>/processes/setup_pgserver.yml

Use a Custom Setting for max_connections in postgresql.conf

To set database server settings besides predefined variables, the hook post_pgserver_configuration_hook has to be implemented. Depending on the scope of the hook (project or installation), the file post_pgserver_configuration_hook.yml has to be stored in the directory global_hooks or installation_hooks. Also see Concept - Ansible4IOM Server Configuration Management 1.0 - 1.1.

- name: update postgreSQL configuration
  ini_file:
    dest: "{{PGSERVER_DATA}}/postgresql.conf"
    section: ""
    option: "{{item.option}}"
    value: "{{item.value}}"
  with_items:
    - { option: max_connections, value: 500 }
  become: true
  become_user: "{{PGServerOSUser}}"

Now the process setup_pgserver can be executed.

ANSIBLE_LIBRARY=<path to Ansible4IOM>/modules/ ANSIBLE_ROLES_PATH=<path to Ansible4IOM>/roles/ ansible-playbook -i <path to inventory file> <path to Ansible4IOM>/processes/setup_pgserver.yml