Postgres:Database Creation - Revision history

Pelibby16 at 17:09, 2 October 2023

2023-10-02T17:09:10Z

← Older revision		Revision as of 17:09, 2 October 2023
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>~~

Pelibby16 at 17:21, 29 September 2023

2023-09-29T17:21:26Z

← Older revision		Revision as of 17:21, 29 September 2023
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>

Bdmarsh13 at 19:15, 14 November 2016

2016-11-14T19:15:14Z

← Older revision		Revision as of 19:15, 14 November 2016
Line 1:		Line 1:
	# Make sure the user that will be using the database is created ([[Postgres:User Creation\|Creating a user]])		# Make sure the user that will be using the database is created ([[Postgres:User Creation\|Creating a user]])
	# Either as the "~~pgsql~~" user, or as the user that will be using the db, run <tt>createdb</tt>		# Either as the "postgres" user, or as the user that will be using the db, run <tt>createdb</tt>
	#* <tt>createdb</tt> can be run with no paramenters, in which case a database is created who's name and owner are that of the current user.		#* <tt>createdb</tt> 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: <tt>createdb <Options> ''dbname'' ''description''</tt>		#* Syntax is: <tt>createdb <Options> ''dbname'' ''description''</tt>

Fitz at 16:29, 4 August 2006

2006-08-04T16:29:41Z

New page

# Make sure the user that will be using the database is created ([[Postgres:User Creation|Creating a user]])
# Either as the "pgsql" user, or as the user that will be using the db, run <tt>createdb</tt>
#* <tt>createdb</tt> 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: <tt>createdb <Options> ''dbname'' ''description''</tt>
#* 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 <tt>man createdb</tt> at a prompt.