Ansible role for PostgreSQL
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
defaults
handlers
meta
tasks
templates/etc/postgresql/10/main
tests
.travis.yml
README.md

README.md

pyslackers.postgres

Build Status

Ansible role to install and configure PostgreSQL.

Installation

To install this roles clone it into your roles directory.

$ git clone https://github.com/pyslackers/ansible-role-postgres.git pyslackers.postgres

If your playbook already reside inside a git repository you can clone it by using git submodules.

$ git submodule add -b master https://github.com/pyslackers/ansible-role-postgres.git pyslackers.postgres

Role Variables

  • postgres_version: Version of postgres (default to 10).

  • postgres_locale: Locale used for postgres databases (default to en_US.UTF-8).

  • postgres_default_roles: List of default user roles (default to NOSUPERUSER,NOCREATEDB,NOCREATEROLE).

  • postgres_listen_address: Listening address of Postgres (default to localhost).

  • postgres_listen_port: Listening port of Postgres (default to 5432).

  • postgres_users: Dict of users and databases to creates with username as key.

    • password: User password.
    • roles: User roles (use postgres_default_roles if not set).
    • database: Name of database to create (default to the user name).
    • privileges: List of Postgres privileges for this role (optional).
      • type: Type of database object to set privileges on.
      • privileges: List of privileges.
      • objs: Lift of Object on which to apply the privileges.
      • state: One of present, absent (default to present).
  • postgres_clients: List of clients allowed to connect.

    • db: Required.
    • user: Required.
    • address: Default to 127.0.0.1/32.
    • peer: Default to md5.
    • type: Default to host.

Example Playbook

- hosts: localhost
  vars:
    postgres_listen_address: '127.0.0.1'
    postgres_listen_port: '5555'
    postgres_extra_packages:
      - pgtop
      - autopostgresqlbackup
    postgres_users:
      sirbot:
        password: foobar123
      pyslackers-website:
        password: baz1234
        roles:
          - 'NOSUPERUSER'
          - 'NOCREATEDB'
        privileges:
          - {type: database, privileges: ['CREATE']}
          - {type: schema, privileges: ['CREATE'], objs: ['public'], state: absent}
    postgres_clients:
      - {db: sirbot, user: sirbot}
      - {db: pyslackers-website, user: pyslackers-website, address: 0.0.0.0/0, peer: trust}
  roles: 
    - pyslackers.postgres

License

MIT