main.yml 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091
  1. ---
  2. - name: Package cache updated
  3. shell: pkg update -f
  4. - name: PostgreSQL packages installed
  5. pkgng:
  6. name: "postgresql12-server postgresql12-client postgresql12-contrib py37-psycopg2"
  7. state: present
  8. - name: PostgreSQL enabled
  9. shell: sysrc postgresql_enable="YES"
  10. - name: PostgreSQL access file patched
  11. patch:
  12. src: pg_hba.conf.patch
  13. dest: /var/db/postgres/data12/pg_hba.conf
  14. become_user: postgres
  15. notify: PostgreSQL restarted
  16. - name: PostgreSQL config file patched
  17. patch:
  18. src: postgresql.conf.patch
  19. dest: /var/db/postgres/data12/postgresql.conf
  20. become_user: postgres
  21. notify: PostgreSQL restarted
  22. - name: PBP database exists
  23. postgresql_db:
  24. name: "pbp"
  25. state: present
  26. become_user: postgres
  27. - name: 15Five database exists
  28. postgresql_db:
  29. name: "fifteen5"
  30. state: present
  31. become_user: postgres
  32. - name: 15Five database has btree_gist extension
  33. postgresql_ext:
  34. name: btree_gist
  35. db: fifteen5
  36. become_user: postgres
  37. - name: 15Five database has btree_gin extension
  38. postgresql_ext:
  39. name: btree_gin
  40. db: fifteen5
  41. become_user: postgres
  42. - name: 15Five database has ltree extension
  43. postgresql_ext:
  44. name: ltree
  45. db: fifteen5
  46. become_user: postgres
  47. - name: 15Five database has hstore extension
  48. postgresql_ext:
  49. name: hstore
  50. db: fifteen5
  51. become_user: postgres
  52. - name: 15Five database exists
  53. postgresql_db:
  54. name: "fifteen5_jail"
  55. state: present
  56. become_user: postgres
  57. - name: 15Five database has btree_gist extension
  58. postgresql_ext:
  59. name: btree_gist
  60. db: fifteen5_jail
  61. become_user: postgres
  62. - name: 15Five database has btree_gin extension
  63. postgresql_ext:
  64. name: btree_gin
  65. db: fifteen5_jail
  66. become_user: postgres
  67. - name: 15Five database has ltree extension
  68. postgresql_ext:
  69. name: ltree
  70. db: fifteen5_jail
  71. become_user: postgres
  72. - name: 15Five database has hstore extension
  73. postgresql_ext:
  74. name: hstore
  75. db: fifteen5_jail
  76. become_user: postgres