Skip to content

Instantly share code, notes, and snippets.

@sperlic

sperlic/pgsql madness

Created August 11, 2014 19:23
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 sperlic/e86a3ce5dc511acae797 to your computer and use it in GitHub Desktop.
Save sperlic/e86a3ce5dc511acae797 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pgsql madness
- name: create postgres root user
postgresql_user: db=postgres
name={{ postgres_root_user }}
password={{ postgres_root_pass }}
role_attr_flags=SUPERUSER,LOGIN,CREATEDB,CREATEROLE,REPLICATION
when: datadir_path.stat.exists == false
- name: check postgres root user
postgresql_user: db=postgres
login_user={{ postgres_root_user }}
login_password={{ postgres_root_pass }}
login_host=127.0.0.1
name={{ postgres_root_user }}
password={{ postgres_root_pass }}
role_attr_flags=SUPERUSER,LOGIN,CREATEDB,CREATEROLE,REPLICATION
when: datadir_path.stat.exists
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment