Details for revision 154 of 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
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
Text

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

  1. Boot from CD or USB in real hardware or run the image in Testdrive
  2. Choose the desired language
  3. Select "Install Ubuntu Server"
  4. Choose the language
  5. Select your location
  6. Configure locales
  7. At configure keyboard page, select NO
  8. Select the country of the keyboard
  9. Select the keyboard layout
  10. Select hostname ubuntu as default
  11. Inser the name for the new user
  12. Insert the name for the account
  13. Choose a password
  14. Reinsert the password
  15. At encrypt request select NO
  16. Verify or setup the timezone
  17. At partitioning select "Guided - Use entire disk"
  18. Select disk to partition
  19. At "Write changes to disks", verify that everythings is right and select YES
  20. At "http proxy" request, let it blank and press enter
  21. At managing upgrades select "No automatic updates"
  22. At Software selection, choose "PostgreSQL database"
  23. Select to install Grub in the master boot record
  24. Remove the installation media (CDROM or USB key)
  25. Wait that the system reboot and login

Verify that the database is running:

  1. sudo -u postgres psql -l
    should return a list of databases.

Verify that can create a database user:

  1. sudo -u postgres createuser -DRS ${USER}
    should create a user.

Verify that can create a database:

  1. sudo -u postgres createdb -O ${USER} ${USER}_db
    should create a database.

Verify that can connect to the database:

  1. 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
.