How to Install PostgreSQL 10 in Windows 10 and Linux

Mini Bytes: In this tutorial i am going to explain you about how to install PostgreSQL 10 in windows 10 and Linux operating system. Since there are many ways to install PostgreSQL 10, i am going to follow GUI installation in Window 10 and command line installation in Linux (Ubuntu 17.04 & CentOS 7).

As the first step i am going to show you how to install PostgreSQL 10 in windows 10.

How to install PostgreSQL 10 in Windows 10:

Before installing PostgreSQL 10 in windows 10, we need to get the PostgreSQL setup file. For this we need to go to the installer provider. Currently there are 2 installers available.

  1. EnterpriseDB
  2. BigSQL

I prefer Enterprise DB because starting from the first i am using the enterprise DB package and found not issues while installing the PostgreSQL database.

Enterprise DB is providing all the required packages available for all the platforms such as windows, linux in both 32-bit and 64-bit.

You can download PostgreSQL 10 package for windows 10 from here.

Here is a simple video tutorial for you on installing PostgreSQL 10 in windows 10.

Location: Postgresql 10 from windows 10

postgresql_download

If you are using 64-bit version of windows then you need to install 64-bit version of postgresql 10 to get full featured performance. You can also install 32-bit version of postgresql 10 in 64-bit version of windows 10, but you may face some performance degradation.

postgresql 10.1 is the latest major release and it has more features that improves the performance of queries. Below are some of the major features which was available the postgresql 10.1.

Major enhancements in PostgreSQL 10 include:

  • Logical replication using publish/subscribe
  • Declarative table partitioning
  • Improved query parallelism
  • Significant general performance improvements
  • Stronger password authentication based on SCRAM-SHA-256
  • Improved monitoring and control

Though you may consider this release as the major release from PostgreSQL 9.6 to 9.10, logical replication and declarative table partitioning is considered to be the useful feature in this release for me.

Its because, when i ran the performance check between both the versions i can see only 2 to 3 milliseconds of difference between 9.6 and 9.10. Lets go in to the installation part.

Step 1:

As the first step when you start the installation, it will check for the Microsoft Visual C++ 2013 redistributable package. You need to install this package manually if you are using PostgreSQL binary installation package.

You can get the package from here Microsoft Visual C++ 2013

postgresql_10_1

In this step, you need to select the “Next” button.

Step 2:

In the next step, you need to specify the installation directory for PostgreSQL 10. But default it will point to the below directory location

C:\Program Files\PostgreSQL\10

If you need to change the location path, then you can change the location path. Keep in mind, this path is different from the data directory path where the actual database files gets stored.

postgresql_10_2

In this step, leave it as it is or change the required location and select “Next”.

Step 3:

Here you can install the following components.

  • PostgreSQL 10 Server
  • PgAdmin
  • Stack Builder
  • Command Line Tools

If you are a database administrator, all the above mentioned tools are important, but if you are going to test or learn about PostgreSQL 10, then you may need only the first two tools.

PgAdmin is the latest tool which you can use to browse the database visually. I has lot more features when compared to the previous version. But i recommend you to use global database browser tools, because it provides more features when compared to PgAdmin 4. I will go for all the components.

postgresql_10_3

Here, select the features you need and select the button “Next”.

Step 4:

This is the main part during the installation, because this is the place where you need to select the data directory where the PostgreSQL database files resides.

You need to make sure that, the drive which you are specifying here should have maximum free space if you are going to use the PostgreSQL in production.

Here important configuration files such as pg_hba.conf and postgresql.conf files will be deployed by the installer.

Here i am going to leave it as it is because i am having enough space in my c drive for PostgreSQL 10 installation.

postgresql_10_4

In this step can specify the location for the data directory or leave it as it is and select the “Next” button.

Step 5:

In this step you need to provide the password for the default account “postgres”. This account will be created during the installation of PostgreSQL 10. So you don’t need to create any specific account for login.

You can also create different users after the installation using PgAdmin 4 or by any other database browser.

Please give a strong password to secure our database.

postgresql_10_5

In this step give strong password in both the text box and select “Next”.

Step 6:

Here, you need to select a port which PostgreSQL 10 use to communicate over the network. By default PostgreSQL uses 5432 port and if you need to be secure, then you can manually specify a valid port in this step.

Here i am going to leave it with the default port 5432.

postgresql_10_6

In this step, specify the port number and hit “Next”.

Step 7:

In the next step, specify the locale i.e. language which you are are going to use in the PostgreSQL 10. I will leave it as default.

postgresql_10_7

In this step select the language and select “Next” button.

Step 8:

This is the last step and here you can see the installation options which you have selected in the previous sections. If you found anything wrong or if you  want to change any installation settings then you need to go back and make the changes.

postgresql_10_8

So if you are OK with the PostgreSQL 10 settings, then you can hit “Next” to proceed the installation.

postgresql_10_9

After the installation completes, you can login into the PostgreSQL 10 using the PgAdmin 4 with the following username “postgres” and password which you have specified during the installation.

Now lets see how to install PostgreSQL 10 in Linux. Here we are going to see how to install PostgreSQL 10 in Ubuntu and also we can see how to install PostgreSQL 10 in CentOS 7

Below is a simple video tutorial on installing PostgreSQL 10 binaries in Window 10.

How to install PostgreSQL 10 in Linux:

If you want to install PostgreSQL in GUI mode then you need to download PostgreSQL 10 for Ubuntu and CentOS 7. From the below link you can download the packages for both the distributions.

PostgreSQL for Ubuntu & PostgreSQL for CentOS

If you are planning to install PostgreSQL 10 in Ubuntu 17.04 and CentOS 7 using the online repository, then you don’t need to download the packages.

Install PostgreSQL 10 in Ubuntu 17.04:

Inorder to install Postgresql in ubuntu, as the first step you need add the repository content in the repository file to download the content from online repository.

Below are the steps to create the repository in Ubuntu 17.04 and install it.

Step 1:

After opening the Terminal in Ubuntu, you must create repository file.

After creating the file add the following lines in to the file pgdg.list

For Ubuntu 17.04:

For Ubuntu 16.04:

For Ubuntu 14.04:

Step 2:

Now you must import the repository signing key using the command below.

if you have successfully imported the signing key, then you must update your ubuntu using the following command.

Step 3:

You have successfully added apt repository for PostgreSQL. Now use the following command to install the PostgreSQL server in Ubuntu.

You may need to give password when it asks you, after that it will create all the data folders, postgres user etc.

Note: It will install the PostgreSQL 10 with the default settings such as port (5432), data directory location etc. If you want to change the default settings, then you need to make modifications in postgresql.conf file.

Install PostgreSQL 10 in CentOS 7:

In order to install Postgresql 10 in CentOS 7 distribution, you first need to install the rpm repository for postgresql-10. With the help of the below command, you can install the rpm repository.

Note: This RPM repository may vary depending on the distribution you are using. For fedora related distribution you can refer this link to get the appropriate rpm repository.

If you have successfully installed the rpm repository for PostgreSQL 10, then you can start the installation with the help of below command.

After the installation completes, you need to run the below command to initialize the database. This step will ask you the port number, data directory location, installation location etc.

After giving the required settings, you need to restart the postgresql-10 service using below command.

To make sure the service is on after rebooting the server you need to use the following command. If not then you need to start the PostgreSQL 10 server every time you reboot your server.

So these are the simple steps which you can use to install PostgreSQL in your windows 10 and Linux (Ubuntu & CentOS). If you like the post please share and please leave your comments below.

Below is a simple video tutorial on installing PostgreSQL 10 in linux.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

4 × 3 =