This repository has been 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 |
| Pratik Gadiya | pgadiya | Reviewer | Independent |
| Alexander Popov | popov83 | 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 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_initdb to support initdb (create a new PostgreSQL database cluster)
- Implement protection from SQL injections in all modules by using query params for psycopg2. See #64661
- Add new module postgresql_fd_wrapper
- Add new module postgresql_fd_server
- Change postgresql_ext module to check double quotes in passed params using module_utils.database.pg_qoute_identifier (the schema param should be presented), see other modules
- Use pg_quote_identifier for all modules, needs to be rechecked and added where needed
- Review open pull-requests -- open PRs
- Review open issues -- open issues
- postgresql_funcs (new module to create, replace or alter functions)
- 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