PostgreSQL collection for Ansible

Contributing to this collection

How to get started quickly, see the CONTRIBUTING.md.

We use the following guidelines:

• CONTRIBUTING.md
• Ansible Community Guide
• Ansible Development Guide
• Ansible Collection Development Guide

We, the PostgreSQL working group, use the community pinboard for general announcements and discussions.

External requirements

The PostgreSQL modules rely on the Psycopg2 PostgreSQL database adapter.

Tested with Ansible

• 2.9
• 2.10
• 2.11
• devel

Included content

• Info modules:

  • postgresql_info
  • postgresql_ping
  • postgresql_user_obj_stat_info

• Basic modules:

  • postgresql_db
  • postgresql_ext
  • postgresql_lang
  • postgresql_pg_hba
  • postgresql_privs
  • postgresql_set
  • postgresql_schema
  • postgresql_tablespace
  • postgresql_query
  • postgresql_user

• Other modules:

  • postgresql_copy
  • postgresql_idx
  • postgresql_membership
  • postgresql_owner
  • postgresql_publication
  • postgresql_sequence
  • postgresql_slot
  • postgresql_subscription
  • postgresql_table

Using this collection

Installing the Collection from Ansible Galaxy

Before using the PostgreSQL collection, you need to install it with the Ansible Galaxy CLI:

ansible-galaxy collection install community.postgresql

You can include it in a requirements.yml file and install it via ansible-galaxy collection install -r requirements.yml, using the format:

---
collections:
  - name: community.postgresql

You can also download the tarball from Ansible Galaxy and install the collection manually wherever you need.

See Ansible Using collections for more details.

Release notes

See the changelog.

Roadmap

See the release plan.

More information

• Ansible Collection overview
• Ansible User guide
• Ansible Developer guide
• Ansible Community code of conduct

Licensing

GNU General Public License v3.0 or later.

See LICENSE to see the full text.