community / community.general / 1.3.14 / module / postgresql_publication Add, update, or remove PostgreSQL publication Authors: Loic Blot (@nerzhul) <loic.blot@unix-experience.fr>, Andrew Klychkov (@Andersson007) <aaklychkov@mail.ru>community.general.postgresql_publication (1.3.14) — module
Install with ansible-galaxy collection install community.general:==1.3.14
collections: - name: community.general version: 1.3.14
Add, update, or remove PostgreSQL publication.
- name: Create a new publication with name "acme" targeting all tables in database "test". community.general.postgresql_publication: db: test name: acme
- name: Create publication "acme" publishing only prices and vehicles tables. community.general.postgresql_publication: name: acme tables: - prices - vehicles
- name: > Create publication "acme", set user alice as an owner, targeting all tables. Allowable DML operations are INSERT and UPDATE only community.general.postgresql_publication: name: acme owner: alice parameters: publish: 'insert,update'
- name: > Assuming publication "acme" exists and there are targeted tables "prices" and "vehicles", add table "stores" to the publication. community.general.postgresql_publication: name: acme tables: - prices - vehicles - stores
- name: Remove publication "acme" if exists in database "test". community.general.postgresql_publication: db: test name: acme state: absent
db: aliases: - login_db description: - Name of the database to connect to and where the publication state will be changed. type: str name: description: - Name of the publication to add, update, or remove. required: true type: str port: aliases: - login_port default: 5432 description: - Database port to connect to. type: int owner: description: - Publication owner. - If I(owner) is not defined, the owner will be set as I(login_user) or I(session_role). type: str state: choices: - absent - present default: present description: - The publication state. type: str tables: description: - List of tables to add to the publication. - If no value is set all tables are targeted. - If the publication already exists for specific tables and I(tables) is not passed, nothing will be changed. If you need to add all tables to the publication with the same name, drop existent and create new without passing I(tables). elements: str type: list ca_cert: aliases: - ssl_rootcert description: - Specifies the name of a file containing SSL certificate authority (CA) certificate(s). - If the file exists, the server's certificate will be verified to be signed by one of these authorities. type: str cascade: default: false description: - Drop publication dependencies. Has effect with I(state=absent) only. type: bool ssl_mode: choices: - allow - disable - prefer - require - verify-ca - verify-full default: prefer description: - Determines whether or with what priority a secure SSL TCP/IP connection will be negotiated with the server. - See U(https://www.postgresql.org/docs/current/static/libpq-ssl.html) for more information on the modes. - Default of C(prefer) matches libpq default. type: str login_host: description: - Host running the database. type: str login_user: default: postgres description: - The username used to authenticate with. type: str parameters: description: - Dictionary with optional publication parameters. - Available parameters depend on PostgreSQL version. type: dict trust_input: default: true description: - If C(no), check whether values of parameters I(name), I(tables), I(owner), I(session_role), I(params) are potentially dangerous. - It makes sense to use C(no) only when SQL injections via the parameters are possible. type: bool version_added: 0.2.0 version_added_collection: community.general session_role: description: - Switch to session_role after connecting. The specified session_role must be a role that the current login_user is a member of. - Permissions checking for SQL commands is carried out as though the session_role were the one that had logged in originally. type: str version_added: 0.2.0 version_added_collection: community.general login_password: description: - The password used to authenticate with. type: str login_unix_socket: description: - Path to a Unix domain socket for local connections. type: str
alltables: description: - Flag indicates that all tables are published. returned: if publication exists sample: false type: bool exists: description: - Flag indicates the publication exists or not at the end of runtime. returned: always sample: true type: bool owner: description: Owner of the publication at the end of runtime. returned: if publication exists sample: alice type: str parameters: description: Publication parameters at the end of runtime. returned: if publication exists sample: publish: delete: false insert: false update: true type: dict queries: description: List of executed queries. returned: always sample: - DROP PUBLICATION "acme" CASCADE type: str tables: description: - List of tables in the publication at the end of runtime. - If all tables are published, returns empty list. returned: if publication exists sample: - '"public"."prices"' - '"public"."vehicles"' type: list