ansible.builtin.postgresql_ext (v2.4.3.0-1) — module

Add or remove PostgreSQL extensions from a database.

| "added in version" 1.9 of ansible.builtin"

Authors: Daniel Schep (@dschep)

preview | supported by community

Install Ansible via pip

Install with pip install ansible==2.4.3.0.post1

Description

Add or remove PostgreSQL extensions from a database.


Requirements

Usage examples

  • Success
    Steampunk Spotter scan finished with no errors, warnings or hints.
# Adds postgis to the database "acme"
- postgresql_ext:
    name: postgis
    db: acme

Inputs

    
db:
    default: null
    description:
    - name of the database to add or remove the extension to/from
    required: true

name:
    default: null
    description:
    - name of the extension to add or remove
    required: true

port:
    default: 5432
    description:
    - Database port to connect to.
    required: false

state:
    choices:
    - present
    - absent
    default: present
    description:
    - The database extension state
    required: false

login_host:
    default: localhost
    description:
    - Host running the database
    required: false

login_user:
    default: null
    description:
    - The username used to authenticate with
    required: false

login_password:
    default: null
    description:
    - The password used to authenticate with
    required: false