--- - 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