This section covers the installation of PostGIS, the spatial extension for PostgreSQL. Version 1.3 of PostGIS will be installed via the PostGIS Windows installer.
Navigate to the workshop software directory.
Run the PostGIS installer by double-clicking the file named postgis-pg82-setup-1.3.3-1.exe, or alternatively by right-clicking on the file and selecting Open.
Running the PostGIS installer
Accept the License Agreement and click Next.
Reviewing the PostGIS licence agreement
Continue through the next two screens accepting the defaults.
Accepting installation defaults
Specifying the install location
On the Database Connection screen specify the password “postgres” and click Next.
Specifying the PostgreSQL connection information
Accept the default database name “postgis”, and click Install.
Specifying a database name
Finalize the installation and exit the installer.
Finishing the PostGIS installation
At this point PostGIS should be installed and ready to use. The installation can be verified by starting windows command prompt and executing the command:
C:\Program Files\PostgreSQL\8.2\bin\psql -U postgres -l
If a database named “template_postgis” is returned in the list then installation was carried out successfully.