Install PostgreSQL on Windows and access using pgadmin 4

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

What is PostgreSQL ?

PostgreSQL is an open-source, object-relational database management system (ORDBMS) that emphasizes extensibility and robustness. It is commonly referred to as “Postgres” and is known for its reliability, scalability, and extensive features.

PostgreSQL supports various platforms, including Windows, macOS, and Linux, and it can be used for a wide range of applications, from small-scale projects to large-scale enterprise systems. It is highly regarded for its ability to handle complex workloads and large amounts of data.

What is pgadmin?

pgadmin is a web-based GUI tool used to interact with the Postgres database sessions, both locally and remote servers as well. You can use pgadmin to perform any sort of database administration required for a Postgres database.

Key features of PostgreSQL Database:

  1. Data integrity: PostgreSQL enforces the ACID (Atomicity, Consistency, Isolation, Durability) properties to ensure data integrity and reliability.
  2. Extensibility: It allows users to define custom data types, operators, and functions, making it highly extensible and adaptable to specific needs.
  3. SQL support: PostgreSQL supports the SQL standard and offers a rich set of SQL features, including complex queries, triggers, and views.
  4. Concurrency control: It provides concurrent access to the database, allowing multiple users to read and write data simultaneously while maintaining consistency.
  5. Replication and high availability: PostgreSQL supports various replication methods, allowing for data replication across multiple servers to enhance availability and fault tolerance.
  6. Full-text search: It includes advanced full-text search capabilities, enabling efficient searching and indexing of text data.
  7. Geospatial support: PostgreSQL has robust support for geospatial data types and provides functions for performing spatial operations and queries.
  8. Security: It offers various security features such as access control mechanisms, SSL encryption, and authentication methods to protect data.

PostgreSQL is widely used in both commercial and open-source projects and has a vibrant community that contributes to its development and maintenance. Its open-source nature allows users to modify and enhance its functionality, making it a flexible and powerful choice for database management.

How to download and Install PostgreSQL on windows ?

Step #1:Download Postgresql on 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.

click download

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.

next5 set password

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

next6 port

Choose the advanced option.

next7 advanced

Check the pre installation summary and click on next.

next8 pre installer

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

next9 ready to install

Postgresql installation is completed, click on finish.

click 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();
verify postgres 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.

enter password

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

create db

Give the name of new database

name db

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

sql tab new db

Then you can see new database created.

new created db 1


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

About Priti Adkine

I am Priti Adkine working as Software Engineer and having 1+ years of Experience. Likes to share knowledge.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Share via
Copy link