# Install PostgreSQL on Windows Server 2016

PostgreSQL is an open source object-relational database system with over 15 years of active development and a reputation for reliability. This database management system supports the SQL92 and SQL99 standards and provides a number of own extensions. PostgreSQL is fully ACID-compliant and it includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP.

Furthermore, this database management system provides interfaces to ODBC and JDBC as well as programming interfaces to a variety of development languages.

PostgreSQL runs stored procedures in more than a dozen programming languages, including Java, Perl, Python, Ruby, Tcl, C/C++, and its own PL/pgSQL, which is similar to Oracle's PL/SQL. Included with its standard function library are hundreds of built-in functions that range from basic math and string operations to cryptography and Oracle compatibility.

Learn how to install PostgreSQL on Windows Server 2016.

## Requirements

- A Cloud Server with Windows Server 2016

## Download the Installer

Connect to the Cloud Server with Remote Desktop. Open a browser window and go to the [PostgreSQL Windows Installers page](https://www.postgresql.org/download/windows/ "PostgreSQL Windows Installer"). Click **Download the installer** to download the installer to the server.

[![Image: install-postgresql-windows-server-2016-01](https://www.ionos.com/digitalguide/fileadmin/_processed_/6/6/csm_install-postgresql-windows-server-2016-01_3803edc1ac.webp "install-postgresql-windows-server-2016-01")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2021/install-postgresql-windows-server-2016-01.jpg)      Select the most recent version of PostgreSQL and the operating system (Windows x86-64) then click **DOWNLOAD NOW**.

[![Image: install-postgresql-windows-server-2016-02](https://www.ionos.com/digitalguide/fileadmin/_processed_/a/0/csm_install-postgresql-windows-server-2016-02_f48b702e52.webp "install-postgresql-windows-server-2016-02")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2021/install-postgresql-windows-server-2016-02.jpg)      ##  Install PostgreSQL

Open the postgresql-\[version\]-windows-x64.exe file, which you downloaded in the previous step.

This will launch the PostgreSQL installation wizard. Click **Next** to begin the installation process.

[![Image: install-postgresql-windows-server-2016-03](https://www.ionos.com/digitalguide/fileadmin/_processed_/1/e/csm_install-postgresql-windows-server-2016-03_6e6783c784.webp "install-postgresql-windows-server-2016-03")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2021/install-postgresql-windows-server-2016-03.jpg)      Specify the directory where you want to install PostgreSQL, then click **Next** to continue.

[![Image: install-postgresql-windows-server-2016-04](https://www.ionos.com/digitalguide/fileadmin/_processed_/f/3/csm_install-postgresql-windows-server-2016-04_395dd1b80e.webp "install-postgresql-windows-server-2016-04")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2021/install-postgresql-windows-server-2016-04.jpg)      Select the components you wish to install. By default, all components will be installed. Click **Next** to continue.

[![Image: install-postgresql-windows-server-2016-05](https://www.ionos.com/digitalguide/fileadmin/_processed_/c/d/csm_install-postgresql-windows-server-2016-05_714a2d6ea7.webp "install-postgresql-windows-server-2016-05")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2021/install-postgresql-windows-server-2016-05.jpg)      Select the directory where you want PostgreSQL to store its data, then click **Next** to continue.

[![Image: install-postgresql-windows-server-2016-06](https://www.ionos.com/digitalguide/fileadmin/_processed_/d/b/csm_install-postgresql-windows-server-2016-06_34379ee855.webp "install-postgresql-windows-server-2016-06")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2021/install-postgresql-windows-server-2016-06.jpg)      Enter the password you want to set for the database administrative user (postgres). Click **Next** to continue.

[![Image: install-postgresql-windows-server-2016-07](https://www.ionos.com/digitalguide/fileadmin/_processed_/f/b/csm_install-postgresql-windows-server-2016-07_9fc983f9ee.webp "install-postgresql-windows-server-2016-07")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2021/install-postgresql-windows-server-2016-07.jpg)      Select the port number you want PostgreSQL to listen on. By default, this will be port 5432. Note: If you wish to access PostgreSQL from the web, you will need to add a firewall policy to allow access to this port.

Click **Next** to continue.

[![Image: install-postgresql-windows-server-2016-08](https://www.ionos.com/digitalguide/fileadmin/_processed_/0/5/csm_install-postgresql-windows-server-2016-08_7b7ccdf0b8.webp "install-postgresql-windows-server-2016-08")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2021/install-postgresql-windows-server-2016-08.jpg)      Select the default locale (time zone) for the PostgreSQL database cluster. Click **Next** to continue.

[![Image: install-postgresql-windows-server-2016-09](https://www.ionos.com/digitalguide/fileadmin/_processed_/e/b/csm_install-postgresql-windows-server-2016-09_c6940cd45c.webp "install-postgresql-windows-server-2016-09")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2021/install-postgresql-windows-server-2016-09.jpg)      Confirm the settings you want to use. If you wish to change any of the settings, click **Back** until you reach the relevant step. After you have verified that the settings are correct, click **Next** to continue.

[![Image: install-postgresql-windows-server-2016-10](https://www.ionos.com/digitalguide/fileadmin/_processed_/0/6/csm_install-postgresql-windows-server-2016-10_96986e19da.webp "install-postgresql-windows-server-2016-10")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2021/install-postgresql-windows-server-2016-10.jpg)      Click **Finish** to complete the installation.

[![Image: install-postgresql-windows-server-2016-11](https://www.ionos.com/digitalguide/fileadmin/_processed_/b/b/csm_install-postgresql-windows-server-2016-11_d9255b75cd.webp "install-postgresql-windows-server-2016-11")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2021/install-postgresql-windows-server-2016-11.jpg)      You can now access PostgreSQL by going to **Start > PosgreSQL 10 > pgAdmin** or **Start > PosgreSQL 10 > SQL Shell (psql)**.


This is a markdown version of: [https://www.ionos.com/digitalguide/server/configuration/install-postgresql-on-windows-server-2016/](https://www.ionos.com/digitalguide/server/configuration/install-postgresql-on-windows-server-2016/) for AI/LLM consumption.