Exercise2.md

Exercise: Extending PostgreSQL Setup with Database and Table Creation

Objective: Enhance the existing Ansible playbook to include tasks for creating a PostgreSQL database and defining tables within it.

Instructions:

1. Current Ansible Playbook:

---
- name: Install PostgreSQL and configure database
  hosts: localhost
  become: yes  # Run tasks with sudo (root) privileges

  vars:
    postgres_db_name: "your_database_name"
    postgres_user: "your_username"
    postgres_password: "your_password"

  tasks:
    - name: Install PostgreSQL and its dependencies
      apt:
        name: "{{ item }}"
        state: present
      with_items:
        - postgresql

    - name: "Install Python packages"
      pip: "name={{ item }}  state=present"
      with_items:
        - psycopg2-binary

    - name: "Find out if PostgreSQL is initialized"
      ansible.builtin.stat:
        path: "/var/lib/pgsql/data/pg_hba.conf"
      register: postgres_data

    - name: "Start postgresql service"
      shell: "/etc/init.d/postgresql start"

    - name: Create database
      remote_user: root
      become: yes
      become_method: su
      become_user: postgres
      postgresql_db:
        name: my_db

2. Tasks to Extend the Playbook:

   a. Task 1: Create a PostgreSQL Database

   • Add a task to create a new PostgreSQL database with a specified name.
   • Utilize the postgresql_db Ansible module for this task.

   b. Task 2: Define Tables in the Database

   • Extend the playbook to include tasks that define tables within the created database.
   • Use the postgresql_table Ansible module to define tables with specific columns.

3. Hints:

   • Refer to the Ansible documentation for the postgresql_db and postgresql_table modules.
   • Consider using variables for the database and table names to make the playbook more flexible.
   • Test the extended playbook on a local environment before applying it to production.

4. Important

   • Debian reqiuers the following authentication, for each postgres command. Copy & Paste the following lines between - name:... and the postgres module.

     remote_user: root
     become: yes
     become_method: su
     become_user: postgres