Postgres:Database Creation

1. Make sure the user that will be using the database is created (Creating a user)
2. Either as the "postgres" user, or as the user that will be using the db, run createdb
   • createdb can be run with no paramenters, in which case a database is created who's name and owner are that of the current user.
   • Syntax is: createdb <Options> dbname description
   • Options:
     1. -D tablespace: Specify default tablespace
     2. -e: Echos the command that createdb generates
     3. -E encoding: Specify character encoding to be used
     4. -O owner: Specify
     5. -q: Do not desplay a response
     6. -T template: Specify template database to use
3. All this and more can be found by typing man createdb at a prompt.

Making Student DB for class

We have a script for creating a PSQL user and database, specifically for classes that involve database concepts. The script (/var/lib/postgresql/create-database.sh).

Run as: bash create-database.sh [username]

The default password for user databases is abc.123