pyslackers.postgres

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