Install PostgreSQL for Microsoft Windows

Overview

CAST does not provide a PostgreSQL installer for Microsoft Windows. Customers must install an official PostgreSQL release obtained from EnterpriseDB external link.

Supported PostgreSQL releases

See What are the database requirements?.

Download

Download the Windows installer for your chosen PostgreSQL release (64-bit) from:

https://www.enterprisedb.com/downloads/postgres-postgresql-downloads external link

CAST recommends PostgreSQL 18.x. Select a release that is supported by CAST (see table above).

Installation

Run the downloaded installer with administrator privileges and follow the interactive wizard. CAST recommends the following settings:

  • Installation directory: accept the default (e.g. %PROGRAMFILES%\PostgreSQL\<version>)
  • Data directory: accept the default (e.g. %PROGRAMFILES%\PostgreSQL\<version>\data)
  • Port: set to 2284 (CAST default; change the pre-filled 5432 value)
  • Locale: set to C
  • Password for the postgres superuser: set a password of your choice

Leave all other options at their defaults.

What is installed?

Files

All PostgreSQL binaries are stored in:

%PROGRAMFILES%\PostgreSQL\<version>\

Microsoft Windows Service

A Windows Service called postgresql-x64-<version> is created and set to start automatically. You may need to adjust firewall rules to allow incoming connections on the listening port (2284).

What next?

See Post installation information and action items.