In focus

How To Install PostgreSQL 9.5

In this article you will learn how to install PostgreSQL.

Anmol Garg May 04, 2016

PostgreSQL is another very good object-relational database management system. You may know others like SQL, ORACLE, MySQL etc. PostgreSQL is a open source database system. It is basically designed to run on UNIX like platforms. But as per the demand later on it designed to be portable, so that it could run on various platforms such as Mac OS X, Solaris and Windows.

Most Common features of PostgreSQL
  • It has User-defined types.
  • It has Table inheritance.
  • It has Sophisticated locking mechanism.
  • It has Foreign key referential integrity.
  • It has Views, rules, sub-select.
  • It has Nested transactions (save points).
  • It has Multi-version concurrency control.
  • It has Asynchronous replication.
There are two steps to complete the PostgreSQL installation
  • Download PostgreSQL installer for Windows
  • Install PostgreSQL
Download PostgreSQL Installer for Windows

You need to download the installer, go to the PostgreSQL official website, then go to the download section for Windows or you can just click on this Link
  • Click on the download installer from EnterpriseDB.
  • Choose the latest version to download. It takes few minutes to complete the download.
Install PostgreSQL Step by Step

Double click on the installer file, an installation wizard will appear and guide you through multiple steps where you can choose different options that you would like to have in PostgreSQL.

The following illustrates each step and its options for installation. If you install a different version, you may get additional steps.

Step 1: Start Installing PostgreSQL

Step 2: Specify installation folder, choose your own or keep the default folder suggested by PostgreSQL installer.

Step 3: Enter the password for the database superuser and service account.

Step 4: Enter the port for PostgreSQL. Make sure that no other applications are using this port. Leave it as default if you are unsure.

Step 5: Choose the default locale used by the database.

Step 6: You’ve completed providing information for the PostgreSQL installer. Click the Next button to install PostgreSQL

The installation may take few minutes to complete.

Click the Finish button to complete the PostgreSQL installation.

Here's a free e-book on PostgreSQL: PostgreSQL 9.5.1 Documentation

database postgresql