PostgreSQL

PostgreSQL Working Group

The PostgreSQL Working Group collaborates on PostgreSQL and PostgreSQL-related technologies (incl. EnterpriseDB) in Ansible.

News

• We formed a Working Group to improve the PostgreSQL-specific support in Ansible.
• We have a PostgreSQL pinboard, subscribe to it to stay informed!

Community

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).

Ideas

(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 -- @Andersson007.
• Add new module postgresql_subscription with support PostgreSQL 10+ (free).
• Implement more options for postgresql_lang, at least, "owner"
• Recheck existing tests (all options covered, etc.), improve tests for all modules, move them from main.yml to separate files
• Add support for tablespaces in postgresql_db module #37953 -- @m4ci3k2 ???
• postgresql_ext add support for a specific extension version (not finished is here, but please, don't mix all in one PR like there)
• Completely rewrite unittests for module_utils/postgres.py (using pytest)

Action plan

v2.9 release

• New PostgreSQL modules:
  • postgresql_publication -- @nerzhul #31939
  • postgresql_sequence -- @tcraxs #55027
• Review open pull-requests -- open PRs
• Review open issues -- open issues

Done

• 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
• slot, membership, ext, idx, lang, owner, query, schema, tablespace, table, set: movied connection related code to connect_to_db() in module_utils/postgres.py -- @Andersson007 #55514
• postgres_privs, it uses postgres_common_argument_spec, though it goes on an adds login, password again -- @Andersson007 #54717
• Move connection params (login_user, login_host, etc.) from all modules to a separate file -- @Andersson007 #55363
• Move the code related with connection establishment to postgres.py/connect_to_db() for postgresql_info and postgresql_ping module (maybe for old modules: db, user, privs too) -- @Andersson007 #55549

future

• TBD

Links

• 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