Details for testcase: Install (PostgreSQL database server)



BugReport a bug against the content of this testcase
ID1407
TitleInstall (PostgreSQL database server)
LinkNo link provided
Part of testsuitesUbuntu Server

RevisionWritten on the 2016-04-25 10:06 by flocculant
Text

Scope of this test is to verify that the system is installed, you can login into it and the database is running.

Proceed in your native language if you wish. Instructions will remain in English

Boot up the image
Choose the desired language
Select "Install Ubuntu Server"
Choose the language
Select your location
Configure locales
At configure keyboard page, select NO
Select the country of the keyboard
Select the keyboard layout
Select hostname ubuntu as default
Insert the name for the new user
Insert the name for the account
Choose a password
Reinsert the password
At encrypt request select NO
Verify or setup the timezone
At partitioning select "Guided - Use entire disk"
Select disk to partition
At "Write changes to disks", verify that everythings is right and select YES
At "http proxy" request, leave it blank and press enter
At managing upgrades select "No automatic updates" with arrows, select it with "space bar" and confirm with "Enter"
At Software selection, choose "PostgreSQL database"
Select to install Grub in the master boot record
Remove the installation media (CDROM or USB key)
Wait that the system reboot and login
Verify that the database is running:
sudo -u postgres psql -l
should return a list of databases.
Verify that can create a database user:
sudo -u postgres createuser -DRS ${USER}
should create a user.
Verify that can create a database:
sudo -u postgres createdb -O ${USER} ${USER}_db
should create a database.
Verify that can connect to the database:
psql ${USER}_db
should start a psql shell connected to the database.

If all actions produce the expected results listed, please submit a 'passed' result.
If an action fails, or produces an unexpected result, please submit a 'failed' result and file a bug. Please be sure to include the bug number when you submit your result.

RevisionWritten on the 2014-01-23 10:58 by nskaggs
RevisionWritten on the 2013-10-07 11:24 by nskaggs
RevisionWritten on the 2013-06-04 18:53 by nskaggs
RevisionWritten on the 2013-03-28 16:29 by nskaggs
RevisionWritten on the 2012-10-11 13:57 by nskaggs
RevisionWritten on the 2012-08-17 09:18 by fabiomarconi
RevisionWritten on the 2012-08-16 11:53 by fabiomarconi