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
Free Cloud Server Trial from IONOS
Try out a Cloud Server for free now - test your IONOS Cloud Server for 30 days!
Download the Installer
Connect to the Cloud Server with Remote Desktop. Open a browser window and go to the PostgreSQL Windows Installers page. Click Download the installer to download the installer to the server.
Select the most recent version of PostgreSQL and the operating system (Windows x86-64) then click DOWNLOAD NOW.
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.
Specify the directory where you want to install PostgreSQL, then click Next to continue.
Select the components you wish to install. By default, all components will be installed. Click Next to continue.
Select the directory where you want PostgreSQL to store its data, then click Next to continue.
Enter the password you want to set for the database administrative user (postgres). Click Next to continue.
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.
Select the default locale (time zone) for the PostgreSQL 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 installation.
You can now access PostgreSQL by going to Start > PosgreSQL 10 > pgAdmin or Start > PosgreSQL 10 > SQL Shell (psql).
Related articles
How to Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 16.04
Learn how to use PostgreSQL with your Ruby on Rails application, instead of the default SQLite database. SQLite is an easy-to-configure, lightweight product which ships with Ruby on Rails by default. However, PostgreSQL is a more robust solution which provides more advanced features, scaling, and stability, which may make it more suitable for your Ruby on Rails project.
PostgreSQL “Could not connect to server” Error: How to troubleshoot
One of the most common errors that occur when using PostgreSQL is the “Could not connect to server” error that results in a refused connection. Usually, the error can be fixed by taking just a few simple steps. In this article, we will show you how to fix a PostgreSQL that cannot connect to the server in Linux. Read on for more.
PostgreSQL: a closer look at the object-relational database management system
The PostgreSQL database management system, also known to many as Postgres, has many decades of development behind it. It originally started as a project at Berkeley University in California. Today, the open source database continues to defy solutions from commercial competitors, since the development team is constantly working on its functionality and performance. But what exactly is PostgreSQL?…
Install phpMyAdmin on CentOS 7
PhpMyAdmin is a convenient way to manage MySQL/MariaDB for those who prefer a browser-based interface over the traditional command-line interface. Learn how to install and use phpMyAdmin on a Cloud Server with Linux (CentOS 7).
BEST-BACKGROUNDSShutterstock Use The Webalizer to Analyze Apache Web Logs
The Webalizer is a free, open source application for analyzing Apache log files. It provides highly detailed and configurable web usage reports in an HTML format which you can view in a browser. Learn how to install The Webalizer on a Cloud Server, and configure the server to automatically run this application at regular intervals in order to update the statistics.
How to install PostgreSQL on Ubuntu
The object-relational database management system PostgreSQL is one of the most popular open-source solutions for servers. You can also install PostgreSQL on Ubuntu 20.04. This is very simple to do. Read on to find out how to install PostgreSQL on Ubuntu and create a new database. You’ll also learn what resources you will need for your PostgreSQL server.
