Installing PostGIS on Windows v3.2

You must install Advanced Server before installing PostGIS. If you have used the graphical Setup wizard to install EDB Postgres Advanced Server, you can use StackBuilder Plus to add PostGIS to your installation. For details about using the graphical installer to install and configure Advanced Server, see the EDB Postgres Advanced Server Installation Guide for Windows.


To install PostGIS version 3.1 on EDB Postgres Advanced Server version 10 on Windows, you need to upgrade it to the latest EDB Postgres Advanced Server minor version of 10.16.25 (or later), and then proceed with PostGIS 3.1 installation.

  1. Open StackBuilder Plus and select your Advanced Server installation from the drop-down list on the Welcome window. Click Next to continue to the application selection page.

    The StackBuilder Plus Welcome window Fig. 1: The StackBuilder Plus Welcome window

  2. Expand the Spatial Extensions node, and check the box next to the PostGIS version. Click Next to continue.

  3. The selected packages and the default download directory are displayed; change the locations if required. Click Next.

    The Installation Directory window Fig. 2: The Installation Directory window

  4. Once you have downloaded the installation files, a confirmation message is displayed. Click Next to start the PostGIS installation.

    Installing Postgis Fig. 3: Installing Postgis

  5. Select an installation language and click OK.

  6. The PostGIS welcome screen is displayed. Click Next.

    The Postgis welcome window Fig. 4: The Postgis welcome window

  7. Use the Installation Directory field to specify the directory you wish to install the PostGIS software. Click Next to continue.

  8. Use fields on the EDB Postgres Advanced Server Installation Details window to provide connection information for the Advanced Server host:

    • Use the Host field to identify the system on which Advanced Server resides.

    • Provide the name of the role that PostGIS will use for connections to the server in the User Name field.

    • Provide the password associated with the role in the Password field.

    • Use the Port field to identify the listener port that Advanced Server monitors for client connections.

      Click Next to continue.

      The Advanced Server installation details window Fig. 5: The Advanced Server installation details window

  9. The Ready to Install window notifies you when the installer has all of the information needed to install PostGIS on your system. Click Next.

    The ready to install window Fig. 6: The ready to install window

  10. Progress bars inform you as the installation progresses. Click Finish to exit the installer when the PostGIS installation completes.

    The installation is complete

    Fig. 7: The installation is complete

    StackBuilder Plus will install PostGIS and create the template_postgis database and PostGIS functions.