postgresql for ansible
Version: | 0.3.0 |
---|---|
Web: | https://github.com/equipindustry/ansible-role-postgresql |
Download: | http://github.com/equipindustry/ansible-role-postgresql |
Source: | http://github.com/equipindustry/ansible-role-postgresql |
Keywords: | ansible-role-postgresql |
Table of Contents:
A role for deploying and configuring PostgreSQL and extensions on unix hosts using Ansible It can additionally be used as a playbook for quickly provisioning hosts. Vagrant machines are provided to produce a boxed install of PostgreSQL or a VM for integration testing.
Supported PostgreSQL versions:
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6
- PostgreSQL 9.5
- PostgreSQL 9.4
- PostgreSQL 9.3
Supported targets: - Ubuntu 14.04 LTS "Trusty Tahr" - Ubuntu 12.04 LTS "Precise Pangolin" - Debian (untested) - RedHat (untested)
- Linux
- none
- OSX
- Homebrew must be installed.
The default role variables in defaults/main.yml
are:
# PostgreSQL
postgresql_version: 9.4
postgresql_listen_addresses:
- '*'
postgresql_databases:
- name: 'test_data'
port: 5432
postgresql_users:
- db: 'name_database'
name: 'user'
password: 'P@ssw0rd'
priv: ALL
role_attr_flags: SUPERUSER
Enabled Postgis
postgresql_postgis: yes
None
See the examples directory.
To run this playbook with default settings, create a basic playbook like this:
- hosts: servers
roles:
- postgresql
To install a specific version:
- hosts: servers
roles:
- { role: equipindustry.postgresql }
To make generate backup:
postgresql_backups:
- name: "{{ postgresql_database_name }}"
user: "{{ postgresql_user }}"
pass: "{{ postgresql_pass }}"
host: "127.0.0.1"
bucket: "{{ aws_bucket_backup }}"
bucket_path: "{{ application_stage }}"
user_system: "{{ user }}"
- hosts: servers
roles:
- role: equipindustry.postgresql
backup_only: yes
If you want to support this project, i only accept IOTA
:p.
Address: FTDCZELEMOQGL9MBWFZENJLFIZUBGMXLFVPRB9HTWYDYPTFKASJCEGJMSAXUWDQC9SJUDMZVIQKACQEEYPEUYLAMMD
![]() |
Luis Mayta |
The code in this repository is licensed under the Apache unless otherwise noted.
Please see LICENSE for details.
Please see CHANGELOG for more information what has changed recently.
Contributions are welcome!
Review the CONTRIBUTING for details on how to:
Releases are managed using bitbucket release feature. We use [Semantic Versioning](http://semver.org) for all the releases. Every change made to the code base will be referred to in the release notes (except for cleanups and refactorings).
Feel free to contact me to discuss any issues, questions, or comments.
Made with ☕ and 🍕 by Luis Mayta and equipindustry.