How to Install PostgreSQL on Windows Servers

PostgreSQL Overview

PostgreSQL is an open source ORM system with more than 15 years of continuous development and a proven, robust architecture. PostgreSQL has won the hearts of millions of users as well as numerous top-level industry awards for database software systems. As a result, more and more PostgreSQL hosting providers can be found on the market offering installation, 24h support, and other PostgreSQL-specific extras.

Downloading the installer

Open a browser tab and go to the PostgreSQL -EnterpriseDB website to download the installer. Select the latest version (version 10.3 at the time of writing of this article). Then select your operating system. Finally click the “download now” link to complete the process.

How to Install PostgreSQL 10

Download the Windows version: PostgreSQL – [10.3] –windows – x64.exe and then open it. Navigate to the download folder location and double-click the file to run the installer.

Once you click next, by default, the Setup installs the PostgreSQL on the C directory, but you can always choose a different folder or directory on your local hardware.

Select the components: by default – all components are selected.

Select where you want PostgreSQL to store its data.

Enter the password for the database superuser. This password is set for security purposes and is in fact the administrator user.

Select a port number, by default it is usually port 5432. You can always configure the firewall so that you can access the database from the web.

Select a default locale or time zone and the default language. You choose your location here.

Finally, confirm the settings you have just configured. Whenever you want you can go back to any setting you want to redo. If satisfied click next to continue.

Additional utilities and add-ons can be installed using the Stack builder.

Finally, click finish to complete the installation.

Select the Postgres Server installed.

 

Select the  additional configuration required and click Next to complete the installation.

Verifying the installation

The quickest way is to use the pgAdmin. At the search bar, search for pgAdmin and then click on the link.

 

The window shows your current installation. In this case: PostgreSQL 10

Connect to the PostgreSQL 10 Instance

Next: double click the PostgreSQL. It prompts for the admin password that you set up earlier during the installation process

If installed correctly, pgAdmin shows us all objects on the server.

Troubleshooting errors

In case you get an error do the following:

  1. Uninstall the app and delete its data in the installation folder.
  2. Create a new user in the Windows account and add it to the administrative group, call it postgres.
  3. Restart your system.
  4. Open your command prompt using the command
    runas /user:posters cmd.exe
  5. Finally, another window appears, and this is where you run the installer.

Conclusion

PostgreSQL is one of the best-performing relational databases that is available to developers today. It is an excellent choice for most business applications that consider data mining, analytics, and reporting as important requirements. Amazon is using PostgreSQL for data warehousing. Redshift, also implements a somewhat modified version of the framework.

However, PostgreSQL is not a good Object Database model (ODM). For projects on which ODM database support is required, programmers & developers are advised to consider MongoDB.

 

Check out the top 3 Windows hosting services:

HostArmada
$2.49 /mo
Starting price
Visit HostArmada
Rating based on expert review
  • User Friendly
    4.5
  • Support
    4.5
  • Features
    4.5
  • Reliability
    4.5
  • Pricing
    4.0
Kamatera
$4.00 /mo
Starting price
Visit Kamatera
Rating based on expert review
  • User Friendly
    3.5
  • Support
    3.0
  • Features
    3.9
  • Reliability
    4.0
  • Pricing
    4.3
Hostens
$2.00 /mo
Starting price
Visit Hostens
Rating based on expert review
  • User Friendly
    4.5
  • Support
    3.8
  • Features
    4.3
  • Reliability
    4.5
  • Pricing
    4.8

How to Install PostgreSQL on an Ubuntu VPS Running Nginx

Brief description Having a remote database system with a client library, one ma
2 min read
Max Ostryzhko
Max Ostryzhko
Senior Web Developer, HostAdvice CTO

How to Move Your WordPress Site from Your Local Web Server to Your Live Site

You can always accelerate the development process by developing your WordPress s
4 min read
Max Ostryzhko
Max Ostryzhko
Senior Web Developer, HostAdvice CTO

How to Set Up Replication on PostgreSQL on Ubuntu 18.04 VPS or Dedicated Server

High availability and load balancing are important concepts in database manageme
4 min read
Vladimir Rakov
Vladimir Rakov
Hosting Expert

How to Install PostgreSQL Database Server on CentOS 7

PostgreSQL is an object relational database that is open source. PSQL is a core
2 min read
Kennedy Mbuvi
Kennedy Mbuvi
Author
HostAdvice.com provides professional web hosting reviews fully independent of any other entity. Our reviews are unbiased, honest, and apply the same evaluation standards to all those reviewed. While monetary compensation is received from a few of the companies listed on this site, compensation of services and products have no influence on the direction or conclusions of our reviews. Nor does the compensation influence our rankings for certain host companies. This compensation covers account purchasing costs, testing costs and royalties paid to reviewers.