Post­greSQL is an open source object-re­la­tion­al database system with over 15 years of active de­vel­op­ment and a rep­u­ta­tion for re­li­a­bil­i­ty. This database man­age­ment system supports the SQL92 and SQL99 standards and provides a number of own ex­ten­sions. Post­greSQL is fully ACID-compliant and it includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP.

Fur­ther­more, this database man­age­ment system provides in­ter­faces to ODBC and JDBC as well as pro­gram­ming in­ter­faces to a variety of de­vel­op­ment languages.

Post­greSQL runs stored pro­ce­dures in more than a dozen pro­gram­ming 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 op­er­a­tions to cryp­tog­ra­phy and Oracle com­pat­i­bil­i­ty.

Learn how to install Post­greSQL on Windows Server 2016.

Re­quire­ments

  • A Cloud Server with Windows Server 2016
Free Cloud Server Trial
En­ter­prise-grade virtual private servers
  • KVM based dev servers for de­vel­op­ers
  • Scalable to en­ter­prise cloud level
  • Pay-as-you-go, per-minute billing

Download the Installer

Connect to the Cloud Server with Remote Desktop. Open a browser window and go to the Post­greSQL Windows In­stallers page. Click Download the installer to download the installer to the server.

Select the most recent version of Post­greSQL and the operating system (Windows x86-64) then click DOWNLOAD NOW.

Install Post­greSQL

Open the post­gresql-[version]-windows-x64.exe file, which you down­loaded in the previous step.

This will launch the Post­greSQL in­stal­la­tion wizard. Click Next to begin the in­stal­la­tion process.

Specify the directory where you want to install Post­greSQL, then click Next to continue.

Select the com­po­nents you wish to install. By default, all com­po­nents will be installed. Click Next to continue.

Select the directory where you want Post­greSQL to store its data, then click Next to continue.

Enter the password you want to set for the database ad­min­is­tra­tive user (postgres). Click Next to continue.

Select the port number you want Post­greSQL to listen on. By default, this will be port 5432. Note: If you wish to access Post­greSQL from the web, you will need to add a firewall policy to allow access to this port.

Click Next to continue.

Select the default locale (time zone) for the Post­greSQL database cluster. Click Next to continue.

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.

Click Finish to complete the in­stal­la­tion.

You can now access Post­greSQL by going to Start > PosgreSQL 10 > pgAdmin or Start > PosgreSQL 10 > SQL Shell (psql).

Go to Main Menu