postgresql

Overview

This is an Ansible role for installing PostgreSQL on Debian. It makes sure the installation is done under the locale en_us.UTF-8. It also installs PostGIS, creates a template_postgis database template, and sets the postgres password. It assumes the duply role is also installed, and creates a pre-backup script that dumps all databases into /var/backups.

Parameters

use_timescale

Default false. Set to true to install Timescale.

postgres_password

The password of the postgres database user. Store this in the vault. The role sets the postgres database user to have this password.

prometheus_server_ips

See the prometheus role.