Download Master`s Thesis

Appendix A
Administrator Manual
This manual is intended to help system administrators set up the database, fill up the raw
data and prepare everything for work. Some of the steps here are optional and can be skipped
or done using a different approach. What we describe here is an exemplary manual for getting
started.
A.1
Installing and setting up a database
The first thing to do is to download and install the required software. For our implementation
we choose to work with the PostgreSQL object-relational database management system with
PostGIS extension pack.
1. Download the latest version of PotgreSQL from http://www.postgresql.org/download/.
Make sure that you got the package suitable for your operating system.
2. Run the downloaded file and install PostgreSQL.
3. During the installation, use StackBuilder to include the PostGIS add-on package.
4. (Optional) PostGIS included in StackBuilder might not be the latest version. We recommend to get and install the latest PostGIS from http://postgis.net/install.
5. The installer for PostgreSQL includes also pgAdmin III (http://www.pgadmin.org/) a graphical tool for managing and developing databases. Locate pgAdmin III and open
it.
6. Create a new server or add an existing one by clicking File → Add Server. Fill the
required information and press ”OK”. For more information and instructions see
the pgAdmin III documentation (www.pgadmin.org/docs/dev/index.html) or PostgreSQL wiki page https://wiki.postgresql.org/wiki/Main_Page.
7. Create a new database in the server by right clicking on ”Databases” in the server menu
and select ”New Database”.
City Traffic Visualization
61