-
Notifications
You must be signed in to change notification settings - Fork 0
Install
This document explains how to install the GeoBI project on a Windows server.
You will need:
- Database dump osmbi.sql.bz2 in https://github.com/camptocamp/GeoBI/tree/master/data
- Application archive webbi.war
- An Internet connection to download software packages
You may install 8.4 or 9.0 version of PostgreSQL database. At Camptocamp we use latest version. You can download both version at the following address:
- Windows: http://www.enterprisedb.com/products/pgdownload.do
- Linux: see your package system
- Other: http://www.postgresql.org/download/
Note that version 9.0 has the advantage of automatically installing plpgsql language in newly created databases. If you install version 8.4, you will need to install this language (see Illustration 1). Run the installer with default options.
PostGIS version depends on which PostgreSQL version you installed. You will find everything needed at the following address: http://postgis.refractions.net/download/windows/ (section For PostgreSQL 8.3, 8.4, 9.0 Users)
Run the installer with default options.
PGAdmin III was installed at the same time as PostgreSQL. Open it and create user www-data by right-clicking on Login Roles (see Illustration 2).
Add a new database geodw by right-clicking on Databases (see Illustration 3). Choose www-data as database owner.
Now import GeoBI data into geodw database. Because database is big, don't use PgAdmin III. Use a Windows command line instead:
- Run pg_env.bat
- Import data via psql:
-
"C:\Program Files\PostgreSQL\9.0\pg_env.bat" -
psql -f osmbi.sql geodw
-
You may install any version of Tomcat. At Camptocamp we use version 6.0. You'll find the installer at the following address:
Run the installer with default options.
Then move file webbi.war (see Build section) in Tomcat directory webapps, for instance C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps . Restart Tomcat service.
Note that Java 1.6 is required for this application.