Contents


Exercise PostgerSQL

  1. Postgres Server Setup:
    Init a database cluster in a sub-directory "databases/postgresql/data" under your home-directory.
    Start the PostgreSQL server "postmaster" on that directory.
    Connect to the server with a psql client.

  2. Create DB:
    Create a new DB named "workshop" and connect to that DB.
    Drop the workshop DB and re-create it.

  3. Create User:
    Create a new user called "fred".
    Drop fred and recuperate him again.

  4. Quit and Kill:
    Quit the psql client and kill the postmaster server you started.