prac1 - School of Information Technology Department of...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
School of Information Technology Department of Computer Science COS326 – Database Systems Tutorial 1 Practical Date: 5 August 2011(Fri) Task 1: For this tutorial we will be working with PostgreSQL. It is already installed on the computers in the Informationium and the account password is data . (Remember to add the password to the PostgreSQL user account in the Control Panel and to start the server.) Installing PostgreSQL and PostGIS at home: All the installers for these programs are on the CS ftp ( ftp://ftp.cs.up.ac.za ) under Courses/COS326. Download the following files onto your C:\ drive: postgresql-8.4.2-1-windows.exe postgis-pg84-setup-1.5.0-1.exe Install PostgreSQL first and followed by the PostGIS installation. When asked to create a spatial database template, answer Yes. Task 2: Open the pgAdmin console in the Startup menu. The image below is the pgAdmin console, the following functions is highlighted: 1. Query Window, here you can write your SQL queries and execute them. There is an output
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/27/2012 for the course IT 101 taught by Professor Unsure during the Spring '11 term at University of South Africa.

Page1 / 4

prac1 - School of Information Technology Department of...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online