#

## OpenGeo Stack Workshop

# Installing PostGIS

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.

1. Navigate to the workshop `software` directory.

2. 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

3. Accept the License Agreement and click Next.

   Reviewing the PostGIS licence agreement

4. Continue through the next two screens accepting the defaults.

   Accepting installation defaults

   Specifying the install location

5. On the Database Connection screen specify the password “postgres” and click Next.

   Specifying the PostgreSQL connection information

6. Accept the default database name “postgis”, and click Install.

   Specifying a database name

7. 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.

### Navigation

- index
- modules |
- next |
- previous |
- OpenGeo Stack Workshop »
- Working With PostGIS »
- Installing PostGIS