Contents
Exercise PostgerSQL
-
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.
-
Create DB:
Create a new DB named "workshop" and connect to that DB.
Drop the workshop DB and re-create it.
-
Create User:
Create a new user called "fred".
Drop fred and recuperate him again.
-
Quit and Kill:
Quit the psql client and kill the postmaster server you started.