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.
Table of Contents
Step #1:Download Postgresql for Windows
Open your favorite browser and go to PostgreSQL Download official website and click on download installer.
![How to Install PostgreSQL on Windows [2 Steps] 1](https://www.devopshint.com/wp-content/uploads/2023/07/installer.png)
Click on download of specific version of OS. So here I choose latest version of window and Download postgresql exe file.
![How to Install PostgreSQL on Windows [2 Steps] 2](https://www.devopshint.com/wp-content/uploads/2023/07/click-download-1024x182.png)
Step #2:Installing Postgresql Installer on Window
Once you download postgresql is completed, open exe file and we get welcome page of postgresql.
![How to Install PostgreSQL on Windows [2 Steps] 3](https://www.devopshint.com/wp-content/uploads/2023/07/click-next.png)
If you want to update the installation directory location where you want to install postgresql then click on next or Simply click on next.
![How to Install PostgreSQL on Windows [2 Steps] 4](https://www.devopshint.com/wp-content/uploads/2023/07/next2.png)
Select the component which you want to install in postgresql and click on next.
![How to Install PostgreSQL on Windows [2 Steps] 5](https://www.devopshint.com/wp-content/uploads/2023/07/next3.png)
Select the directory of data where you want to save it and click on next.
![How to Install PostgreSQL on Windows [2 Steps] 6](https://www.devopshint.com/wp-content/uploads/2023/07/next4.png)
Set the password of database superuser in postgresql.
![How to Install PostgreSQL on Windows [2 Steps] 7](https://www.devopshint.com/wp-content/uploads/2023/07/next5-set-password.png)
Select the port number and click on next or Simply click on next.
![How to Install PostgreSQL on Windows [2 Steps] 8](https://www.devopshint.com/wp-content/uploads/2023/07/next6-port.png)
Choose the advanced option.
![How to Install PostgreSQL on Windows [2 Steps] 9](https://www.devopshint.com/wp-content/uploads/2023/07/next7-advanced.png)
Check the pre installation summary and click on next.
![How to Install PostgreSQL on Windows [2 Steps] 10](https://www.devopshint.com/wp-content/uploads/2023/07/next8-pre-installer.png)
Now set up is ready to begin installing postgresql so click on next.
![How to Install PostgreSQL on Windows [2 Steps] 11](https://www.devopshint.com/wp-content/uploads/2023/07/next9-ready-to-install.png)
Postgresql installation is completed, click on finish.
![How to Install PostgreSQL on Windows [2 Steps] 12](https://www.devopshint.com/wp-content/uploads/2023/07/click-finish.png)
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
- Psql
- pgAdmin
For psql: Go to start and search psql shell, open it to launch Postgresql. And you will get CLI window.
![How to Install PostgreSQL on Windows [2 Steps] 13](https://www.devopshint.com/wp-content/uploads/2023/07/sqlshell.png)
Now you have verify postgresql version using
select version();
![How to Install PostgreSQL on Windows [2 Steps] 14](https://www.devopshint.com/wp-content/uploads/2023/07/verify-postgres-version.png)
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.
![How to Install PostgreSQL on Windows [2 Steps] 15](https://www.devopshint.com/wp-content/uploads/2023/07/pgadmin.png)
Click on server and enter the password then open by server and database.
![How to Install PostgreSQL on Windows [2 Steps] 16](https://www.devopshint.com/wp-content/uploads/2023/07/enter-password.png)
If you want to create new database the go to database à right click on it click on create à click on create database.
![How to Install PostgreSQL on Windows [2 Steps] 17](https://www.devopshint.com/wp-content/uploads/2023/07/create-db.png)
Give the name of new database
![How to Install PostgreSQL on Windows [2 Steps] 18](https://www.devopshint.com/wp-content/uploads/2023/07/name-db.png)
If you go sql tab then can see query and click on save button.
![How to Install PostgreSQL on Windows [2 Steps] 19](https://www.devopshint.com/wp-content/uploads/2023/07/sql-tab-new-db.png)
Then you can see new database created.
![How to Install PostgreSQL on Windows [2 Steps] 20](https://www.devopshint.com/wp-content/uploads/2023/07/new-created-db-1.png)
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: