README.md

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