postgresql_lang – Adds, removes or changes procedural languages with a PostgreSQL database

• Synopsis
• Requirements
• Parameters
• Notes
• Examples
• Return Values
• Status

Synopsis

• Adds, removes or changes procedural languages with a PostgreSQL database.
• This module allows you to add a language, remote a language or change the trust relationship with a PostgreSQL database.
• The module can be used on the machine where executed or on a remote host.
• When removing a language from a database, it is possible that dependencies prevent the database from being removed. In that case, you can specify casade to automatically drop objects that depend on the language (such as functions in the language).
• In case the language can’t be deleted because it is required by the database system, you can specify fail_on_drop=no to ignore the error.
• Be carefull when marking a language as trusted since this could be a potential security breach. Untrusted languages allow only users with the PostgreSQL superuser privilege to use this language to create new functions.
• For more information about PostgreSQL languages see the official documentation https://www.postgresql.org/docs/current/sql-createlanguage.html, https://www.postgresql.org/docs/current/sql-alterlanguage.html, https://www.postgresql.org/docs/current/sql-droplanguage.html.

Requirements

The below requirements are needed on the host that executes this module.

• psycopg2

Parameters

Notes

Examples

- name: Add language pltclu to database testdb if it doesn't exist
  postgresql_lang: db=testdb lang=pltclu state=present

# Add language pltclu to database testdb if it doesn't exist and mark it as trusted.
# Marks the language as trusted if it exists but isn't trusted yet.
# force_trust makes sure that the language will be marked as trusted
- name: Add language pltclu to database testdb if it doesn't exist and mark it as trusted
  postgresql_lang:
    db: testdb
    lang: pltclu
    state: present
    trust: yes
    force_trust: yes

- name: Remove language pltclu from database testdb
  postgresql_lang:
    db: testdb
    lang: pltclu
    state: absent

- name: Remove language pltclu from database testdb and remove all dependencies
  postgresql_lang:
    db: testdb
    lang: pltclu
    state: absent
    cascade: yes

- name: Remove language c from database testdb but ignore errors if something prevents the removal
  postgresql_lang:
    db: testdb
    lang: pltclu
    state: absent
    fail_on_drop: no

Return Values

Common return values are documented here, the following are the fields unique to this module:

Status

• This module is not guaranteed to have a backwards compatible interface. [preview]
• This module is maintained by the Ansible Community. [community]

Authors

• Jens Depuydt (@jensdepuydt)
• Thomas O’Donnell (@andytom)