PostgreSQL collection for Ansible

External requirements

The PostgreSQL modules rely on the Psycopg2 PostgreSQL database adapter.

Tested with Ansible

• 2.9
• 2.10
• 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.

Contributing to this collection

We're following the general Ansible contributor guidelines; see Ansible Community Guide.

If you want to clone this repositority (or a fork of it) to improve it, you can proceed as follows:

1. Create a directory ansible_collections/community;
2. In there, checkout this repository (or a fork) as postgresql;
3. Add the directory containing ansible_collections to your ANSIBLE_COLLECTIONS_PATH.

See Ansible's dev guide for more information.

There is also the community pinboard used by the PostgreSQL working group for announcements and discussing general questions.

Release notes

See the changelog.

Roadmap

See the release plan. See blah blah

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.