Manual PostgreSQL installation¶

A manual installation of PostgreSQL if typically done if: - a different versions of PostgreSQL databases should be used, compared to the one provided by with the MIKE OPERATIONS installer. - the database should be installed on a different computer than MIKE OPERATIONS

Warning

PostgreSQL has a limitted 5-year period of support for each major version of PostgreSQL.
After this period, PostgreSQL will not release security and hotfixes for the version. This also mean that MIKE OPERATIONS will not support these versions with new releases.
Read more on the PostgreSQL version policy page and on DHI Developers.

PostgreSQL installers for Windows can be found on the EDB PostgreSQL Download page.

Please follow the instructions below to install PostgreSQL.

For more information about installing PostgreSQL, please refer to Installing PostgreSQL on Windows on EDB Docs.

PostgreSQL Installation¶

This section explains how to install a PostgreSQL installer downloaded from the web page of Enterprise DB.

Run the database installation program e.g. postgresql-XX.X-X-windows-x64.exe

Start of installation

Accept the default installation folder.

Select the components to install.

Accept the default data folder.

Type in a password of your choice for the postgres user (the administrator for the database server).

Tip

Do not forget this password as it is required when using the MIKE OPERATIONS Database Manager Utility as well as any other tools for managing the PostgreSQL database, e.g. pgAdmin.

Accept the port number (the default port used by PostgreSQL is 5432 for the first PostgreSQL database service installation).

If more PostgreSQL servers are installed, the first free port number after port 5432 is suggested.

Leave the Locale as Default Locale

Review the installation summary.

Click Next

The database server installation has finished.

Uncheck the Launch Stack Builder at exit? option and then click Finish.

PostGIS Manual Installation¶

This section explains how to install PostgreSQL exemplified by using a PostGIS postgis-bundle-pgXXx64-setup-X.X.X-X.exe installer from the OSGeo Download Server.

Run the PostGIS installation program (e.g. postgis-bundle-pg17x64-setup-3.5.0-1).

Note

Note the supported versions of PostGIS for the installed version of PostgreSQL in the Installation Prerequisites section.

Start of installation (License Agreement).

Click I Agree.

Check the Create spatial database and leave remaining components with the default selection.

Accept the default installation location (specifying the PostgreSQL installation directory found by the installer).

Type in the password that was specified for the postgres user when installing the PostgreSQL database server.

Keep the default spatial database name.

The installation has finished.

Click Close

Configuration of PostGIS

Open the Windows Command Prompt.

Click the Windows Start Menu and type cmd.

Right-click on cmd.exe and choose Run as administrator.

In the command prompt type SETX /M PROJSO libproj-9.dll and press Enter.

Restart the computer to make the environment variable available to PostGIS

Mesh Database installation¶

When PostgreSQL is not installed with the MIKE OPERATIONS installer, a dll will be missing for the database to work with Meshes in the GIS Manager. Please read this to know more.