>_ IzzyLab

Topic breakdown

A PostgreSQL cluster is a set of databases managed by a single postgres process, administered on behalf of the system user postgres, who is the DBMS superuser (not to be confused with the OS root). By default authentication goes by the name of the current system user, so commands are run via sudo -u postgres, otherwise psql looks for a nonexistent role root. You can create a database either with the command-line wrapper utility or with the SQL command CREATE DATABASE inside psql — both add a record to the pg_database system catalog. Unquoted identifiers are folded to lowercase, so the name is taken exactly from the task.

What's checked

  1. database shop created

What it looks like