New in version 1.7.
parameter | required | default | choices | comments |
---|---|---|---|---|
cascade |
no |
|
when dropping a language, also delete object that depend on this language. only used when state=absent . | |
db |
no | name of database where the language will be added, removed or changed | ||
fail_on_drop |
no | yes |
|
if yes , fail when removing a language. Otherwise just log and continuein some cases, it is not possible to remove a language (used by the db-system). When dependencies block the removal, consider using cascade . |
force_trust |
no |
|
marks the language as trusted, even if it's marked as untrusted in pg_pltemplate. use with care! | |
lang |
yes | name of the procedural language to add, remove or change | ||
login_host |
no | localhost | Host running PostgreSQL where you want to execute the actions. | |
login_password |
no | Password used to authenticate with PostgreSQL (must match login_user ) | ||
login_user |
no | postgres | User used to authenticate with PostgreSQL | |
port |
no | 5432 | Database port to connect to. | |
state |
no | present |
|
The state of the language for the selected database |
trust |
no |
|
make this language trusted for the selected db |
# 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 - postgresql_lang: db: testdb lang: pltclu state: present trust: yes force_trust: yes # Remove language pltclu from database testdb: - postgresql_lang: db: testdb lang: pltclu state: absent # Remove language pltclu from database testdb and remove all dependencies: - postgresql_lang: db: testdb lang: pltclu state: absent cascade: yes # 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
Note
This module is flagged as preview which means that it is not guaranteed to have a backwards compatible interface.
This module is community maintained without core committer oversight.
For more information on what this means please read Module Support
For help in developing on modules, should you be so inclined, please read Community Information & Contributing, Helping Testing PRs and Developing Modules.