pgAdmin

Creating a pgAdmin lab

K
Written by Kevin Wesley
Updated over a week ago

Modern Vocareum lab types are in general release. Please contact support@vocareum.com to set up a compatible course.

Creating a pgAdmin lab

From your course page navigate to New Assignment. Enter and assignment name and select "Save and continue".

Create a part for the new assignment. Selecting "+" under Parts.

Give the part a name, select the lab type (in this case pgAdmin), and select Save Part.

Select Configure Workspace to open the pgAdmin environment, where you will be prompted to log in. And then taken to the pgAdmin environment

Enter email as "postgres@postgres.com"

Enter password as "password"

Configuring Database Server

Your hostname will always be "localhost"

Enter your password as "password"

File System

Open the Storage Manager under Tools in the pgAdmin toolbar. Here You can find /voc and subdirectories apart of the file system.

Here is a list of all directories that are created by the platform -

  • /voc/course - common to the entire course and not visible to learners

  • /voc/docs - README.md should go here

  • /voc/private - this is a directory for storing lab level resources not visible to the learners

  • /voc/public - lab level directory which is visible to the learner

  • /voc/scripts/grade.sh - store grading scripts here as grade.sh

  • /voc/startercode - store all the content here which is copied to the /home/labsuser directory for the learner

  • /home/labsuser - used for creating quiz.md before running "Generate Quiz" operation. This directory can also be used to develop and test startercode, scripts, etc.

Did this answer your question?