2.4 Creating the database

To create a database, the PostgreSQL server must be up and running. Database is created with SQL command

CREATE DATABASE SQLTUTOR_DATABASE

Two database roles must be created for Sqltutor with SQL command CREATE ROLE

CREATE ROLE SQLTUTOR_WWW_USER LOGIN;
CREATE ROLE SQLTUTOR_WWW_EXEC LOGIN;

To set passwords for these new roles run psql and enter SQL ALTER command

ALTER USER SQLTUTOR_WWW_USER WITH PASSWORD 'xxx';
ALTER USER SQLTUTOR_WWW_EXEC WITH PASSWORD 'yyy';

or passwords can be set directly when creating roles

CREATE ROLE SQLTUTOR_WWW_USER PASSWORD 'xxx' LOGIN;
CREATE ROLE SQLTUTOR_WWW_EXEC PASSWORD 'yyy' LOGIN;

If PostgreSQL language is not defined in datatabase template1 you must create it explicitly in the Sqltutor database

su -
su - postgres
psql SQLTUTOR_DATABASE
CREATE LANGUAGE plpgsql;

This document was generated by Ales Cepek on January 18, 2018 using texi2html 1.82.