luismayta/ansible-role-postgresql

role of postgresql for ansible

Ansible Role for PostgreSQL

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:

• Supports
• Requirements
• Role Variables
• Dependencies
• Example Playbook
• Support
• Team
• License
• Changelog
• Contributing
• Versioning
• Contact Info

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.

Supports

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)

Requirements

• Linux
• none
• OSX
• Homebrew must be installed.

Role Variables

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

Dependencies

None

Example Playbook

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

Support

If you want to support this project, i only accept IOTA :p.

Address: FTDCZELEMOQGL9MBWFZENJLFIZUBGMXLFVPRB9HTWYDYPTFKASJCEGJMSAXUWDQC9SJUDMZVIQKACQEEYPEUYLAMMD

Team

Luis Mayta

License

The code in this repository is licensed under the Apache unless otherwise noted.

Please see LICENSE for details.

Changelog

Please see CHANGELOG for more information what has changed recently.

Contributing

Contributions are welcome!

Review the CONTRIBUTING for details on how to:

Versioning

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).

Contact Info

Feel free to contact me to discuss any issues, questions, or comments.

• Email
• Twitter
• GitHub
• LinkedIn
• Website
• PGP

Made with ☕ and 🍕 by Luis Mayta and equipindustry.