CSI 2132 Lab1

1
CSI 2132 Lab1

• Setting up PostgreSQL
• Arif Emre Caglar

2
Outline

• Overview of PostgreSQL
• Using pgAdmin III in SITE labs
• Setting up pgAdmin III to your home computer.

3
PostgreSQL

• It is a powerful, open source relational database
  management system (RDBMS).
• Since it is open source, it is not controlled by
  any single company. Thus, its development is
  relied on global community of developers and
  companies.
• We can download, install, use and see its source
  code freely.

4
PostgreSQL Components

• We will be using the following in this course.
• PostgreSQL
• pgAdmin III
• PostgreSQL is the core DBMS, including command
  line tools, programming language libraries etc.
  SITE already has a PostgreSQL server, and we will
  be using it.
• pgAdmin III is the graphical client to access our
  database located in SITE server.

5
Your PostgreSQL Account

• SITE PostgreSQL server already created accounts
  for you.
• Username is the standard username you use, i.e.
  If your email is abc42_at_uottawa.ca, then your
  username is abc42.
• Your password is the password you use to login
  the SITE computers.

6
UsIng/settIng Up pgadmIn
7
Using pgAdmin III at SITE

• pgAdmin is already installed in SITE 0110
  computer lab.
• Go to
• Start Menu ? Program Files ? pgAdmin III 1.6 ?
  pgAdmin III
• Click on
• File ? Add Server

8
Server Parameters for SITE

• Name Anything you want
• Host acadb
• Port 5432
• Maintenance DB and Username acagl079 ,
  Password Your SITE account PW

9
Successfull connection and pgAdmin GUI

• Note that you only have access to DB of your
  account.

10
Setting up and using pgAdmin III from your home

• Go to
• http//www.pgadmin.org/download/
• Click to PostgreSQL mirror network.
• Choose v1.8.1
• If you are a Windows user, click to Win32 link.
• Download pgAdmin3-1.8.1.zip
• OsX and Linux users can find the corresponding
  installer or the source installation in the other
  links.

11
Home setup Continued

• Extract the zip file to somewhere, and run
  pgadmin3.msi
• Follow the instructions (i.e Next Buttons) and
  install pgAdmin III.
• Run
• Start Menu ? Program Files ? pgAdmin III 1.8 ?
  pgAdmin III
• Click on File ? Add Server

12
Server Parameters for Home installation

• Name Anything you want
• Host web0.site.uottawa.ca Port
  15432
• Maintenance DB and Username Your Username
• Password Your SITE account Password

13
For Detailed Information

• About PostgreSQL
• http//www.postgresql.org
• About pgAdmin III
• http//www.pgadmin.org
• Connectivity for remote users and SITE computers
• http//www.site.uottawa.ca/local/labinfo/software/
  postgresql.html

14
My Contact

• Arif Emre Caglar
• Email acagl079_at_uottawa.ca
• Office SITE 4023
• Office Hours Tuesday 1500 1600