Difference between revisions of "Postgres:Database Creation"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
#*# -T ''template'': Specify template database to use | #*# -T ''template'': Specify template database to use | ||
# 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== | ||
| + | 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> | ||
Revision as of 13:21, 29 September 2023
- Make sure the user that will be using the database is created (Creating a user)
- 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:
- -D tablespace: Specify default tablespace
- -e: Echos the command that createdb generates
- -E encoding: Specify character encoding to be used
- -O owner: Specify
- -q: Do not desplay a response
- -T template: Specify template database to use
- 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
