How to Install PostgreSQL on Windows [2 Steps]

In this article We are going to perform How to download PostgreSQL on Windows and How to Install PostgreSQL on Windows, Verify installation of PostgreSQL on windows, create database in PostgreSQL.

Step #1:Download Postgresql for Windows                                                                   

Open your favorite browser and go to PostgreSQL Download official website and click on download installer.

Click on download of specific version of OS. So here I choose latest version of window and Download postgresql exe file.

Step #2:Installing Postgresql Installer on Window

Once you download postgresql is completed, open exe file and we get welcome page of postgresql.

If you want to update the installation directory location where you want to install postgresql then click on next or Simply click on next.

Select the component which you want to install in postgresql and click on next.

Select the directory of data where you want to save it and click on next.

Set the password of database superuser in postgresql.

Select the port number and click on next or Simply click on next.

Choose the advanced option.

Check the pre installation summary and click on next.

Now set up is ready to begin installing postgresql so click on next.

Postgresql installation is completed, click on finish.

We have performed How to download PostgreSQL on Windows and Install PostgreSQL on windows.

Step #3:Verify installation of PostgreSQL on windows

We can check installation of Postgresql in two way

1. Psql
2. pgAdmin

For psql: Go to start and search psql shell, open it to launch Postgresql. And you will get CLI window.

Now you have verify postgresql version using

select version();

Step #4:How to connect PostgreSQL Database using pgadmin 4 and Creating a PostgreSQL database with pgAdmin

For pgadmin 4: Go to start and search pgadmin 4, open it to launch postgresql. You will get default screen.

Click on server and enter the password then open by server and database.

If you want to create new database the go to database à right click on it click on create à click on create database.

Give the name of new database

If you go sql tab then can see query and click on save button.

Then you can see new database created.

Conclusion:

We have covered How to download PostgreSQL on Windows and Install PostgreSQL on windows,How to connect PostgreSQL Database using pgadmin 4 and Creating a PostgreSQL database with pgAdmin

Related Articles:

How to Install Postgresql on Ubuntu 22.04 LTS