OpenGeo

OpenGeo Stack Workshop

Previous topic

Installing PostgreSQL

Next topic

Creating a Spatial Database

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.

    ../_images/postgis_install1.jpg

    Running the PostGIS installer

  3. Accept the License Agreement and click Next.

    ../_images/postgis_install2.jpg

    Reviewing the PostGIS licence agreement

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

    ../_images/postgis_install3.jpg

    Accepting installation defaults

    ../_images/postgis_install4.jpg

    Specifying the install location

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

    ../_images/postgis_install5.jpg

    Specifying the PostgreSQL connection information

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

    ../_images/postgis_install6.jpg

    Specifying a database name

  7. Finalize the installation and exit the installer.

    ../_images/postgis_install7.jpg

    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.