{"repo":"ome/ansible-role-postgresql","free":true,"listed":false,"github":"https://github.com/ome/ansible-role-postgresql","clone":"git clone https://github.com/ome/ansible-role-postgresql.git","description":"Install upstream PostgreSQL server. Optionally creates users and databases.","language":"Python","stars":11,"topics":["ansible","role","postgresql","database"],"license":"BSD-2-Clause","category":"databases-storage","readme_excerpt":"Postgresql ========== Install upstream PostgreSQL server. Optionally creates users and databases. If you wish to use your distribution's packages then do not use this role. This role revokes default PUBLIC privileges from database and public schema for all supported versions of PostgreSQL. This is to be inline with the breaking change made in PostgreSQL 15. Role Variables -------------- Defaults: defaults/main.yml - postgresql version : The PostgreSQL major version: 14 , 15 , 16 , 17 , 18 - postgresql package version : The PostgreSQL full version, leave this empty to use the latest minor release from postgresql version , ignored on Ubuntu - postgresql dist redhat or postgresql dist debian : Object that define configuration attributes for PostgreSQL on each specific OS, these variables allow to change the interaction between variables defined at ome.postgresql and ome.postgresql client The following parameters will be ignored if postgresql install server: False : - postgresql databases : List of dictionaries of databases. Items should be of the form: - name : Database name - owner : Owner role (optional) - lc collate : Collation order (LC COLLATE) to use in the database - lc ctype : Character classification (LC CTYPE) to use in the database - encoding : Encoding of the database, default UTF-8 - template : Template used to create the database - postgresql users : List of dictionaries of users. Items should be of the form: - user : Database username - password : Database user pa","default_branch":null,"files":null,"tree":[],"storefront":"/r/ome","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ome/ansible-role-postgresql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}