Postgresql 11 Install In Graphical Mode On Windows 10

Posted on

In this video we will see How to Install PostgreSQL & pgAdmin 4 on Windows 10.The PostgreSQL installers created by EnterpriseDB are designed to make it quick. If you are installing PostgreSQL into a Windows system that is configured with User Account Control (UAC) enabled, you can assume sufficient privileges to invoke the graphical installer by right clicking on the name of the installer and selecting Run as administratorfrom the context menu. If prompted, enter an administrator password to continue.

  1. Postgresql 11 Install In Graphical Mode On Windows 10 Free
  2. Postgresql 11 Install In Graphical Mode On Windows 10 Download
  3. Postgresql 11 Install In Graphical Mode On Windows 10 64-bit
  4. Postgresql 11 Install In Graphical Mode On Windows 10 64

Summary: in this tutorial, you will step by step learn how to install PostgreSQL on your local system.

PostgreSQL was developed for UNIX-like platforms, however, it was designed to be portable. It means that PostgreSQL can also run on other platforms such as macOS, Solaris, and Windows.

Since version 8.0, PostgreSQL offers an installer for Windows systems that makes the installation process easier and faster. For development purposes, we will install PostgreSQL version 12 on Windows 10.

There are three steps to complete the PostgreSQL installation:

  1. Download PostgreSQL installer for Windows
  2. Install PostgreSQL
  3. Verify the installation

1) Download PostgreSQL Installer for Windows

First, you need to go to the download page of PostgreSQL installers on the EnterpriseDB.

Second, click the download link as shown below:

It will take a few minutes to complete the download.

2) Install PostgreSQL on Window step by step

To install PostgreSQL on Windows, you need to have administrator privileges.

Step 1. 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.

Step 2. Click the Next button

Step 3. Specify installation folder, choose your own or keep the default folder suggested by PostgreSQL installer and click the Next button

Step 4. Select software components to install:

  • The PostgreSQL Server to install the PostgreSQL database server
  • pgAdmin 4 to install the PostgreSQL database GUI management tool.
  • Command Line Tools to install command-line tools such as psql, pg_restore, etc. These tools allow you to interact with the PostgreSQL database server using the command-line interface.
  • Stack Builder provides a GUI that allows you to download and install drivers that work with PostgreSQL.

For the tutorial on this website, you don’t need to install Stack Builder so feel free to uncheck it and click the Next button to select the data directory:

Step 5. Select the database directory to store the data or accept the default folder. And click the Next button to go to the next step:

Step 6. Enter the password for the database superuser (postgres)

PostgreSQL runs as a service in the background under a service account named postgres. If you already created a service account with the name postgres, you need to provide the password of that account in the following window.

After entering the password, you need to retype it to confirm and click the Next button:

Step 7. Enter a port number on which the PostgreSQL database server will listen. The default port of PostgreSQL is 5432. You need to make sure that no other applications are using this port.

Step 8. Choose the default locale used by the PostgreSQL database. If you leave it as default locale, PostgreSQL will use the operating system locale. After that click the Next button.

Step 9. The setup wizard will show the summary information of PostgreSQL. You need to review it and click the Next button if everything is correct. Otherwise, you need to click the Back button to change the configuration accordingly.

Now, you’re ready to install PostgreSQL on your computer. Click the Next button to begin installing PostgreSQL.

The installation may take a few minutes to complete.

Step 10. Click the Finish button to complete the PostgreSQL installation.

3) Verify the Installation

There are several ways to verify the PostgreSQL installation. You can try to connect to the PostgreSQL database server from any client application e.g., psql and pgAdmin.

The quick way to verify the installation is through the psql program.

First, click the psql application to launch it. The psql command-line program will display.

Second, enter all the necessary information such as the server, database, port, username, and password. To accept the default, you can press Enter. Note that you should provide the password that you entered during installing the PostgreSQL.

Third, issue the command SELECT version(); you will see the following output:

Congratulation! you’ve successfully installed PostgreSQL database server on your local system. Let’s learn various ways to connect to PostgreSQL database server.

It may look like a complicated task to install PostgreSQL, Oracle, or SQL Server or any other database software, but it really isn’t! These days, most relational database management systems come with installation wizards that make the process much simpler. In this article, we’ll look at how to install PostgreSQL and test that the installation is working.

To install PostgreSQL, we’ll complete the following tasks:

  1. Downloading the PostgreSQL package.
  2. Installing and configuring PostgreSQL.
  3. Starting the postgres server application.
  4. Verifying that PostgreSQL is working.

This database is available on Linux (or Unix), Windows, and macOS platforms. I’ll show you how to install PostgreSQl on Windows 10.

1. Downloading the PostgreSQL Package

To install PostgreSQL on your computer, you can download it from the official site or by using the download link for Windows. Once you’re on the right page, click the “Download the installer” link.

That’ll take you to the following page:

Postgresql 11 Install In Graphical Mode On Windows 10 Free

Here, you’ll need to select the postgres version to download and your operating system. In this article, we’ll work with PostgreSQL version 10 (which, as of now, is the latest available) and a 64-bit Windows 10 operating system.

Click the download button to continue. Once it finishes, you’ll be directed to the following page:

Click the installer that pops up in the bottom-left of your browser (you’ll see it there if you’re using Chrome—if not, double-click the installer from your Downloads folder).

2. Installing and Configuring PostgreSQL

Postgresql 11 Install In Graphical Mode On Windows 10 Download

To show you how to install PostgreSQL on Windows 10, I’ll have to explain the configuration process involved in the installation. It’s a configuration of some important parameters like the port number, your postgres admin password, and more. Don’t worry if you don’t know what any of these things mean! The installation is straightforward.

Postgresql

To start, click Next in the following window.

Choose the directory where you want to install PostgreSQL. It’s recommended that you leave the default as it is. When you’re done, click Next.

The next page shows the components that are going to be installed. Leave these options checked as they are, and click Next again.

Leave the data directory as the default, and click Next.

To install PostgreSQL, you need to choose a password for postgres superuser (administrator) permissions. This password will be used when you connect as the user “postgres” from the SQL client in the verification section at the end of this guide. Click Next when you’re done.

Then, you’ll need to choose the port number that the postgres server will listen to for requests. The default is 5432, but the installation wizard may suggest another if 5432 is already in use. Click Next to continue.

Now, you should see a summary of all parameters you set in the previous steps. Click Next again to move on.

Postgresql 11 Install In Graphical Mode On Windows 10 64-bit

On the following page, simply click Install.

You should see a progress bar like the one below as you install PostgreSQL.

When the installation is complete, you should see the following window:

Stack Builder is optional. Click Finish, and you’re done!

3. Starting PostgreSQL as a Server

After you install PostgreSQL, the software will automatically start. And whenever you restart your computer, postgres will start as well.

Postgresql 11 Install In Graphical Mode On Windows 10 64

However, at any time, you can choose to stop or start the postgresql server yourself. There are a few ways to stop postgresql; the simplest is through Task Manager.

If you navigate to the Services tab, you’ll see the following. On my notebook, I have two postgresql versions installed (10 and 9.6). One is running and one is stopped.

Here, you can start or stop postgres at any time by right-clicking it and selecting the desired action.

4. Verifying Your PostgreSQL Installation

Whenever you install software, it’s always a good idea to verify that the installation was in fact successful. One way to verify the postgresql installation is by connecting to postgresql from any SQL client. When you install PostgreSQL, it comes with the official pgAdmin client as part of the default installation.

Start the pgAdmin application. Then, click File and select Add Server.

In the window that appears, you’ll see a list of properties you can specify. The password is the same one you chose during your postgres installation.

If the connection is successful, you should see something like the following, with PostgreSQL actively listening to the port it is connected to.

Congratulations! You already know how to install PostgreSQL on Windows 10 and verify that it’s working properly. Now, you can begin creating your own databases and running SQL queries in pgAdmin. Have fun!

You may also like