Skip to content

Instantly share code, notes, and snippets.

@rektide
Last active August 29, 2015 13:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rektide/9612510 to your computer and use it in GitHub Desktop.
Save rektide/9612510 to your computer and use it in GitHub Desktop.
Ansible Postgres db creation one-act
---
- hosts: all
sudo: True
sudo_user: postgres
vars:
super_priv: "ALL"
ro_priv: "SELECT"
vars_prompt:
db: "Database"
pw: "Password for user"
super: "Superuser (or blank for db-name)"
ro: "Read-only user (or blank for none)"
ro_pw: "Read-only user password (if applicable)"
tasks:
- set_fact: port=5432
when: port is not defined
- fail: msg="No database"
when: not db
- postgresql_db: name="{{db}}" port="{{port}}"
- postgresql_user: name="{{super|default(db)}}" encrypted="false" password="{{pw}}" db="{{db}}" priv="{{super_priv}}"
when: pw is defined
- postgresql_user: name="{{ro}}" encrypted="false" password="{{ro_pw}}" db="{{db}}" priv="{{ro_priv}}"
when: not not ro
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment