Skip to content

ansible-collections/community.postgresql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

883ffab · Jun 10, 2024
May 10, 2022
May 17, 2024
May 4, 2022
Aug 11, 2023
May 13, 2024
Apr 8, 2024
Oct 22, 2020
May 17, 2024
Feb 19, 2024
Nov 11, 2022
Oct 29, 2020
May 11, 2023
Jul 21, 2021
May 16, 2022
Apr 8, 2024
May 17, 2024
Jun 7, 2023
May 3, 2021
Jun 3, 2022

PostgreSQL collection for Ansible

Build Status Codecov Discuss on Matrix at #postgresql:ansible.com

This collection is a part of the Ansible package.

Code of Conduct

We follow the Ansible Code of Conduct in all our interactions within this project.

If you encounter abusive behavior violating the Ansible Code of Conduct, please refer to the policy violations section of the Code of Conduct for information on how to raise a complaint.

Contributing to this collection

The content of this collection is made by people just like you, a community of individuals collaborating on making the world better through developing automation software.

We are actively accepting new contributors and all types of contributions are very welcome.

You don't know how to start? Refer to our contribution guide!

We use the following guidelines:

Collection maintenance

The current maintainers (contributors with write or higher access) are listed in the MAINTAINERS file. If you have questions or need help, feel free to mention them in the proposals.

To learn how to maintain / become a maintainer of this collection, refer to the Maintainer guidelines.

It is necessary for maintainers of this collection to be subscribed to:

They also should be subscribed to Ansible's The Bullhorn newsletter.

Communication

GitHub Discussions feature is disabled in this repository. Use the postgresql tag on the forum in the Project Discussions or Get Help category instead.

Asynchronous channels

Real-time channels

For more information about communication, including how to join these channels, see the Ansible communication guide.

Governance

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

The process of decision making in this collection is based on discussing and finding consensus among participants.

Every voice is important and every idea is valuable. If you have something on your mind, create an issue or dedicated discussion and let's discuss it!

External requirements

The PostgreSQL modules rely on the Psycopg2 PostgreSQL database adapter.

Releases Support Timeline

We maintain each major release version (1.x.y, 2.x.y, ...) for two years after the next major version is released.

Here is the table for the support timeline:

  • 1.x.y: released 2020-11-17, EOL
  • 2.x.y: released 2022-02-10, supported until 2025-06-09
  • 3.x.y: released 2023-06-09, current
  • 4.x.y: to be released; not earlier than after Ansible 10 release (~May 2024)

Tested with ansible-core

Tested with the following ansible-core releases:

  • 2.14
  • 2.15
  • 2.16
  • 2.17
  • current development version

Ansible-core versions before 2.12.0 are not supported. Our AZP CI includes testing with the following docker images / PostgreSQL versions:

Docker image Psycopg version PostgreSQL version
CentOS 7 2.5.1 9.2
RHEL 8 2.7.5 10
Fedora 37 2.9.6 14
Fedora 38 2.9.6 15
Fedora 39 2.9.6 15
Ubuntu 20.04 2.8.6 15
Ubuntu 22.04 3.1.9 15

Included content

Using this collection

Installing the Collection from Ansible Galaxy

Before using the PostgreSQL collection, you need to install it with the Ansible Galaxy command-line tool:

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.

Note that if you install the collection from Ansible Galaxy with the command-line tool or tarball, it will not be upgraded automatically when you upgrade the Ansible package. To upgrade the collection to the latest available version, run the following command:

ansible-galaxy collection install community.postgresql --upgrade

You can also install a specific version of the collection, for example, if you need to downgrade when something is broken in the latest version (please report an issue in this repository). Use the following syntax:

ansible-galaxy collection install community.postgresql:==X.Y.Z

See Ansible Using collections for more details.

Release notes

See the changelog.

Roadmap

See the release plan.

More information

Licensing

GNU General Public License v3.0 or later.

See LICENSE to see the full text.