Difference between revisions of "Postgres:Database Creation"

From Earlham CS Department
Jump to navigation Jump to search
 
Line 12: Line 12:
 
# All this and more can be found by typing <tt>man createdb</tt> at a prompt.
 
# All this and more can be found by typing <tt>man createdb</tt> at a prompt.
  
−
==Making Student DB for class==
+
[https://wiki.cs.earlham.edu/index.php/Sysadmin:Psql-setup Setting up a simple user DB for classes]
−
We have a script for creating a PSQL user and database, specifically for classes that involve database concepts.
 
−
The script (<code>/var/lib/postgresql/create-database.sh</code>).
 
−
 
 
−
Run as: <code>bash create-database.sh [username]</code>
 
−
 
 
−
The default password for user databases is <code>abc.123</code>
 

Latest revision as of 12:09, 2 October 2023

  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.

Setting up a simple user DB for classes

Retrieved from "https://wiki.cs.earlham.edu/index.php?title=Postgres:Database_Creation&oldid=18131"