PostgreSQL EnterpriseDB installation

This post describes the installation of PostgreSQL using the EnterpriseDB installer. The post is targeted at local installation aimed for development purposes, and not for hosting on a server.

Please download the latest version from here https://www.postgresql.org/download/windows/.

We recommend version 12.x of the installer. 

We also recommend creating the installation directory beforehand (outside of Program files) and give the group “Users” “Full Control” of that directory.

The following screenshots shows the default values of the installer. As we are installing for local development purposes we can safely accept these values, but we recommend changing the installation directory. It is easier to manage permissions and access on directories outside C:\Program Files\

Figure 1: Installation directory

Figure 2: Select components

Figure 3: Data directory

Figure 4: Password

Figure 5: Port

Figure 6: Locale