ansible-roles/postgresql
Eric Morino b92871bfef
Ansible Lint |Total|New|Outstanding|Fixed|Trend |:-:|:-:|:-:|:-:|:-: |2612|5|2607|6|:+1: Reference build: <a href="https://jenkins.evolix.org/job/gitea/job/ansible-roles/job/unstable/320//ansiblelint">Evolix » ansible-roles » unstable #320</a> Détails
gitea/ansible-roles/pipeline/head This commit looks good Détails
Add variable ansible_distribution_release on preference file for fix version of postgresql
2023-08-14 09:29:12 +02:00
..
defaults postgresql: configure max_connections 2023-03-12 11:12:56 +01:00
files postgresql: fix regression introduced in 6c4243f3e in logrotate group 2023-01-04 10:22:43 +01:00
handlers Use FQCN 2023-03-20 23:33:19 +01:00
meta Update Galaxy metadata (company, platforms and galaxy_tags) 2021-06-28 15:26:28 +02:00
tasks postgresql: fix task "update apt cache" for PGDG repo 2023-08-04 09:56:44 +02:00
templates Add variable ansible_distribution_release on preference file for fix version of postgresql 2023-08-14 09:29:12 +02:00
tests Use FQCN 2023-03-20 23:33:19 +01:00
.kitchen.yml Kitchen: Change base image to evolix/ansible 2017-06-02 08:38:08 -04:00
README.md Improve documentation 2017-01-05 18:22:06 +01:00

README.md

PostgreSQL

Installation and basic configuration of PostgreSQL.

Tasks

Tasks are in several files, included in tasks/main.yml :

  • packages.yml : packages installation ;
  • config.yml : configurations ;
  • nrpe.yml : nrpe user for Nagios checks ;
  • munin.yml : Munin plugins ;
  • logrotate.yml : logrotate configuration.

Available variables

Main variables are :

  • postgresql_databases: list of databases for Munin plugins
  • postgresql_shared_buffers: (default: 4GB)
  • postgresql_work_mem: (default: 8MB)
  • postgresql_random_page_cost: (default: 1.5)
  • postgresql_effective_cache_size: (default: 14GB)

The full list of variables (with default values) can be found in defaults/main.yml.