12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091 |
- ---
- - name: Package cache updated
- shell: pkg update -f
- - name: PostgreSQL packages installed
- pkgng:
- name: "postgresql12-server postgresql12-client postgresql12-contrib py37-psycopg2"
- state: present
- - name: PostgreSQL enabled
- shell: sysrc postgresql_enable="YES"
- - name: PostgreSQL access file patched
- patch:
- src: pg_hba.conf.patch
- dest: /var/db/postgres/data12/pg_hba.conf
- become_user: postgres
- notify: PostgreSQL restarted
- - name: PostgreSQL config file patched
- patch:
- src: postgresql.conf.patch
- dest: /var/db/postgres/data12/postgresql.conf
- become_user: postgres
- notify: PostgreSQL restarted
- - name: PBP database exists
- postgresql_db:
- name: "pbp"
- state: present
- become_user: postgres
- - name: 15Five database exists
- postgresql_db:
- name: "fifteen5"
- state: present
- become_user: postgres
- - name: 15Five database has btree_gist extension
- postgresql_ext:
- name: btree_gist
- db: fifteen5
- become_user: postgres
- - name: 15Five database has btree_gin extension
- postgresql_ext:
- name: btree_gin
- db: fifteen5
- become_user: postgres
- - name: 15Five database has ltree extension
- postgresql_ext:
- name: ltree
- db: fifteen5
- become_user: postgres
- - name: 15Five database has hstore extension
- postgresql_ext:
- name: hstore
- db: fifteen5
- become_user: postgres
- - name: 15Five database exists
- postgresql_db:
- name: "fifteen5_jail"
- state: present
- become_user: postgres
- - name: 15Five database has btree_gist extension
- postgresql_ext:
- name: btree_gist
- db: fifteen5_jail
- become_user: postgres
- - name: 15Five database has btree_gin extension
- postgresql_ext:
- name: btree_gin
- db: fifteen5_jail
- become_user: postgres
- - name: 15Five database has ltree extension
- postgresql_ext:
- name: ltree
- db: fifteen5_jail
- become_user: postgres
- - name: 15Five database has hstore extension
- postgresql_ext:
- name: hstore
- db: fifteen5_jail
- become_user: postgres
|