Setup for Introduction to SQL Using PostgreSQL

• Windows 10 or later or Mac: OS X (version 10.12) or later.
• Google Chrome

Class Files

1. The first step to setting up for your course package is to create the folder in which you will store your class files. Create a new folder named Webucator wherever you want, but make sure you remember where it is.
2. Download the class files from the bottom of this page.
3. Unzip the class files into the Webucator folder. This will create a folder called ClassFiles. 

Setup Instructions

1. Download the latest version of PostgreSQL. Be sure to choose the version for your operating system.
2. Once the installer has downloaded, run it by double-clicking on the download or by right-clicking and selecting Open:
   

3. Run through the Setup Wizard. On the Select Components screen, uncheck Stack Builder. Leave the other options checked. Make note of the password you set for the database superuser.

4. If pgAdmin doesn’t open automatically, open it.
   
5. Set up a master password. This is how you will log into pgAdmin.

Setting up the jokesdb Database

1. Open pgAdmin if it is not already open. You may be prompted to enter your master password. 
2. Open Servers, right click on Databases, and select Create > Database…
   
3. Name the database “jokesdb” and click Save.
   
4. Right click on jokesdb and select Restore…
   
5. Select the three dots to open a file explorer-like window:
   
6. Navigate to jokesdb.backup file within the setup folder. Make sure that backup is the Format selected or you may not see the file. Click Select.
   
7.  Click Restore.
   

8. To test if the Restore worked:

   1. Right click on the jokesdb database, and select Query Tool.
      
   2. In the Query Editor, write SELECT * FROM jokes; and then press the Run button.
      
   3. In the Data Output, you should see information on various jokes. You should also get a success message that says “595 rows affected”.
      
      If you missed the success message, you can go to Messages:
      
9. If you have issues with the restore step, it might be a problem with your Binary path. To fix it, do this:

   1. In pgAdmin, open the Query Tool.

      

   2. And then run SELECT version(). You can run it with the Execute button .

      This should output the version:

      

   3. Now go to File > Preferences and then open up Binary paths under Paths.

   4. Change the value of PostgreSQL Binary Path to "C:\Program Files\PostgreSQL\[Your version number]\bin" where [Your version number] is the version number (13.1 in the above image). Also check that the folder with that path exists in your file system.

   5. After you do this, try to restore the jokes database again.

Congratulations! You are all set for class.