This repository was archived by the owner on Jun 10, 2024. It is now read-only.
PostgreSQL
The PostgreSQL Working Group collaborates on PostgreSQL and PostgreSQL-related technologies (incl. EnterpriseDB) in Ansible.
- We formed a Working Group to improve the PostgreSQL-specific support in Ansible.
- We have a PostgreSQL pinboard, subscribe to it to stay informed!
| Name | GitHub (+ IRC) | Role | Affiliation |
|---|---|---|---|
| Andrew Klychkov | Andersson007 | Leader | Independent |
| Strahinja Kustudic | kustodian | Reviewer | Independent |
| Sebastiaan Mannem | sebasmannem | Reviewer | EnterpriseDB |
| Abhijit Menon-Sen | amenonsen / crab | Reviewer | 2ndQuadrant |
| Kostiantyn Nemchenko | kostiantyn-nemchenko | Reviewer | Independent |
| Thomas O'Donnell | andytom | Reviewer | Independent |
| Flavien Chantelot | Dorn- | Reviewer | Independent |
| Tobias Birkefeld | tcraxs | Reviewer | Independent |
| John Scalia | jbscalia | Member | Independent |
Add yourself to this list as a Reviewer (help review PRs) or as a Member (discuss issues/roadmap).
(if you're going to start to work on some, please, inform the community by message here pinboard)
- Add See Also sections to PostgreSQL modules referring related modules and websites
- Add new module postgresql_column with support to add/drop/alter PostgreSQL column (free)
- Add "query" returned values that return the executed queries (only for modules that changes DB: to know that was really happened, for debug, for CI tests).
- Add AES-256 encryption support #41787.
- Add new module postgresql_copy to implement COPY command behavior with all possible params (free).
- Add new module postgresql_subscription with support PostgreSQL 10+ (free).
- Implement more options for postgresql_lang, at least, "owner"
- Move connection params (login_user, login_host, etc.) from all modules to a separate file
- Move the connection class from postgresql_info or connection function from postgresql_owner to module_utils/postgres.py
- Add missing integration tests to parameters related with SSL (ssl_mode, ca_cert, etc.)
- New PostgreSQL modules:
- Review open pull-requests -- open PRs
- Review open issues -- open issues
- Add missing integration tests to postgresql_idx
- New module postgresql_query -- @archf @Andersson007 #52555
- postgresql_ping -- @Andersson007 #51477
- postgresql_tablespace -- @Dorn- @antoinell @Andersson007 #52914
- postgresql_facts -- @Andersson007 #51164
- postgresql_set -- @Andersson007 #51875
- Added missing integration tests for postgresql_ext -- @Andersson007
- Added missing integration tests for postgresql_schema -- @tcraxs #54185
- postgresql_pg_hba -- @sebasmannem #32666
- postgresql_membership -- @Andersson007 #53733
- postgresql_table -- @Andersson007 #52077
- Added missing integration tests for postgresql_lang -- @Andersson007
- postgresql_slot -- @jbscalia, @Andersson007 #55079
- TBD
- How to use Ansible to manage PostgreSQL on opensource.com
- Managing PostgreSQL with Ansible by 2ndQuadrant
- Ansible loves PostgreSQL by 2ndQuadrant
- Automating PostgreSQL provisioning using Ansible
- Beyond Puppet and Chef: Managing PostgreSQL with Ansible by oreilly.com