Role Detail

sfromm.postgresql

Role to manage PostgreSQL
Downloads
238
Type Ansible
Minimum Ansible Version 1.2
Installation $ ansible-galaxy install sfromm.postgresql
Tags
database
sql
Last Commit NA
Last Imported
OS Platforms
Platform Version
EL 7
Last 10 Imports
Completed Status
SUCCESS

PostgreSQL

Ansible role to managed PostgreSQL.

Requirements

The only external dependency is the python bindings for PostgreSQL, which this role will install.

Role Variables

When configuring PostgreSQL, I encourage you to review the PostgreSQL documentation and specifically the documentation on server configuration: 9.3, 9.4, and 9.5. There are several variables available for tuning PostgreSQL. Please refer to defaults/main.yml for a full list. Documented below are some of the variables available for modifying.

  • postgresql_service_name: Name of postgresql service for the init system. Defaults to postgresql.
  • postgresql_admin_user: Name of the administrative user for PostgreSQL. Defaults to postgres.
  • postgresql_locale: Default locale is en_US.UTF-8.
  • postgresql_data_directory: Path to the PostgreSQL data directory, aka PGDATA on Red Hat. Defaults to /var/lib/pgsql/data.
  • postgresql_pid_directory: Path to the PID directory. Defaults to /var/run/postgresql.
  • postgresql_do_backup: Whether to deploy a script to perform database backups. Defaults to no.
  • postgresql_backup_path: Path to where database backups should be kept. Defaults to /var/lib/pgsql/backups.
  • postgresql_backup_age: Maximum age of backups to keep. Defaults to 14.
  • postgresql_backup_compression: Compression to use for backups. Defaults to xz.

You can define client authentication with what is traditionally named pg_hba.conf. There are two variables to control this: postgresql_pg_hba_conf_default and postgresql_pg_hba_conf. The former defines the defaults (described below) and the latter is to provide any additional configuration. The parameter names map to columns in the pg_hba.conf file. Please refer to PostgreSQL's documentation for client authentication.

  • postgresql_pg_hba_conf_default: A list of allowed clients. Each item in the list must define the keys type, database, user, address, and method. The default for this is:
postgresql_pg_hba_conf_default:
 - { type: local, database: all, user: "{{postgresql_admin_user}}", address: '',             method: peer  }
 - { type: host,  database: all, user: all,                         address: "127.0.0.1/32", method: ident }
 - { type: host,  database: all, user: all,                         address: "::1/128",      method: ident }
  • postgresql_pg_hba_conf: This is defined the same as postgresql_pg_hba_conf_default. Each item in the list must define the keys type, database, user, address, and method. This defaults to an empty list.

You can define what databases and users to create using postgresql_databases and postgresql_users.

  • postgresql_databases: A list of databases to manage. Each item in the list may define the keys name (name of the database), owner (owner of the database), encoding (language encoding, defaults to UTF-8), lc_collate (Collation order, defaults to en_US.UTF-8), lc_ctype (Character classification, defaults to same as lc_collate), template (template used to create the database, defaults to template0, and state (defaults to present). It is only necessary to define the name parameter. Example:
postgresql_databases:
  - name: example
  • postgresql_users: A list of users to manage. Each item in the list may define the keys name (name of the database user), password (the user's password), encrypted (a boolean for whether the password is stored hashed in the database), priv (privileges to grant user on a database), database (name of database privileges are associated with), role_attr_flags (role attributes for the user), and state (defaults to present). Only name and password are required.
postgresql_users:
  - name: icarus
    password: poor-password
    database: example
    priv: ALL/products:ALL

Dependencies

No dependency on other roles.

Example Playbook

A trivial example:

- hosts: servers
  roles:
    - { role: sfromm.postgresql }

License

GPLv2

Author Information

See https://github.com/sfromm

None