PostgreSQL

PostgreSQL Working Group

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

(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
Add new module postgresql_funcs (create, replace or alter functions)