Skip to content

Latest commit

 

History

History
153 lines (101 loc) · 3.68 KB

README.md

File metadata and controls

153 lines (101 loc) · 3.68 KB
Raw

postgresql

This role installs and configures PostgreSQL into your system.

Requirements

No special requirements; note that this role requires root access, so either run it in a playbook with a global become: yes, or invoke the role in your playbook like:

- hosts: database
  roles:
    - role: bithium.postgresql
      become: yes

Role Variables

Available variables are listed below, along with default values (see defaults/main.yml and vars/main.yml):

  • Packages to install for each OS: postgresql_package
---
postgresql_package_names:
  Debian: postgresql
  RedHat: postgresql-server

postgresql_package: "{{postgresql_package_names[ansible_os_family]}}"

postgresql_packages:
  - "{{postgresql_package}}"
  • PostgreSQL cluster initialization command (this is only used for RedHat based distributions):
---
postgresql_cluster_init:
  RedHat: {
    v6: "service postgresql initdb",
    v7: "postgresql-setup initdb",
  }

  • Service name:

     postgresql_service: postgresql

  • Cluster name:

---
postgresql_cluster_names:
  Debian: "{{postgresql_version}}/main"
  RedHat: "data"

postgresql_cluster_name: "{{postgresql_cluster_names[ansible_os_family]}}"
  • Cluster data folder:
---
postgresql_var_lib_names:
  Debian: "postgresql"
  RedHat: "pgsql"

postgresql_var_lib_name: "{{postgresql_var_lib_names[ansible_os_family]}}"

postgresql_data_dir: "/var/lib/{{postgresql_var_lib_name}}/{{postgresql_cluster_name}}"
  • Cluster configuration folder:
---
postgresql_config_dirs:
  Debian: "/etc/postgresql/{{ postgresql_cluster_name }}"

postgresql_config_dir: "{{postgresql_config_dirs[ansible_os_family] | default(postgresql_data_dir)}}"

  • Cluster configuration file:

     postgresql_config_file: "{{postgresql_config_dir}}/postgresql.conf"

  • Cluster custom configuration folder:

     postgresql_extra_config_dir: "{{postgresql_config_dir}}/conf.d"

  • Cluster custom configuration file:

     postgresql_extra_config_file: "{{postgresql_extra_config_dir}}/25_ansible.conf"

  • Cluster custom configuration options:

    This is an hash with the options that will be placed in postgresql_extra_config_file as key = value, e.g:

     postgresql_config:
    port: 4242
    max_connections: 50

  • Cluster pg_hba.conf configuration file.

     postgresql_pg_hba_conf_file: "{{postgresql_config_dir}}/pg_hba.conf"

    NOTE: Changing this variable WILL NOT configure the cluster to use the given value as the source for the HBA functionality.

  • Cluster custom pg_hba.conf configuration options:

    This is an array of strings that will be appended to postgresql_pg_hba_conf_file, e.g.:

     postgresql_pg_hba_config:
    - "host all all 168.192.1.0/24 password"
    - "host all all 168.192.1.0/24 md5"

  • Cluster pg_ident.conf configuration file.

     postgresql_pg_ident_conf_file: "{{postgresql_config_dir}}/pg_ident.conf"

    NOTE: Changing this variable WILL NOT configure the cluster to use the given value as the source for the IDENT functionality.

  • Cluster custom pg_ident.conf configuration options:

    This is an array of strings that will be appended to postgresql_pg_ident_conf_file, e.g.:

     postgresql_pg_ident_config:
   - "bithium   /^(.*)@bithium\\.com$      \\1"
   - "bithium   /^(.*)@example\\.com$    guest"

Dependencies

Example Playbook

- hosts: servers
  become: true
  roles:
     - role: postgresql

License

Apache 2.0

Author Information

Bithium S.A.