{"repo":"geerlingguy/ansible-role-postgresql","free":true,"listed":false,"github":"https://github.com/geerlingguy/ansible-role-postgresql","clone":"git clone https://github.com/geerlingguy/ansible-role-postgresql.git","description":"Ansible Role - PostgreSQL","language":"Jinja","stars":654,"topics":["ansible","role","postgresql","postgres","sql","database","setup"],"license":"MIT","category":"databases-storage","readme_excerpt":"Ansible Role: PostgreSQL Installs and configures PostgreSQL server on RHEL/CentOS or Debian/Ubuntu servers. Requirements No special requirements; note that this role requires root access, so either run it in a playbook with a global become: yes , or invoke the role in your playbook like: Role Variables Available variables are listed below, along with default values (see defaults/main.yml ): (RHEL/CentOS only) You can set a repo to use for the PostgreSQL installation by passing it in here. Set the state of the service when configuration changes are made. Recommended values are restarted or reloaded . Library used by Ansible to communicate with PostgreSQL. If you are using Python 3 (e.g. set via ansible python interpreter ), you should change this to python3-psycopg2 . The user and group under which PostgreSQL will run. The directories (usually one, but can be multiple) where PostgreSQL's socket will be created. Control the state of the postgresql service and whether it should start at boot time. Global configuration options that will be set in postgresql.conf . For PostgreSQL versions older than 9.3 you need to at least override this variable and set the option to unix socket directory . If you override the value of option: log directory with another path, relative or absolute, then this role will create it for you. Configure host based authentication entries to be set in the pg hba.conf . Options for entries include: - type (required) - database (required) - user (required) -","default_branch":null,"files":null,"tree":[],"storefront":"/r/geerlingguy","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/geerlingguy/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."}