| 123456789101112131415161718192021222324252627282930313233343536373839 |
- ---
- - name: Install postgresql packages
- dnf:
- name:
- - postgresql
- - postgresql-server
- - postgresql-devel # Allows pip installing psycopg2 is desired
- - python3-psycopg2
- state: present
- - name: Initialize PostgreSQL
- command: postgresql-setup initdb
- args:
- creates: /var/lib/pgsql/data/pg_hba.conf
- - replace:
- dest: /var/lib/pgsql/data/pg_hba.conf
- regexp: "local all all peer"
- replace: "local all all trust"
- - replace:
- dest: /var/lib/pgsql/data/pg_hba.conf
- regexp: "host all all 127.0.0.1/32 ident"
- replace: "host all all 127.0.0.1/32 trust"
- - replace:
- dest: /var/lib/pgsql/data/pg_hba.conf
- regexp: "host all all ::1/128 ident"
- replace: "host all all ::1/128 trust"
- - name: Start postgresql
- service: name=postgresql state=restarted enabled=yes
- - name: Add a pagure postgres user
- postgresql_user: name=pagure role_attr_flags=SUPERUSER,LOGIN
- - name: Create a database for pagure
- postgresql_db: name=pagure owner=pagure
|
