Hi All,

Greetings of the day!

PostgreSQL is open source, free RDBMS and pgAdmin is a client to access PostgreSQL, and today we will look at how we can download and install PostgreSQL & pgAdmin on our windows machine.

For downloading PostgreSQL & pgAdmin we have an installer available at the below link

Download PostgreSQL



After clicking on download a .exe file will be downloaded. Once exe file is downloaded click on that and finish the installation process as shown below.

Click on next and select all options so our pgAdmin will also be installed. If we want to download only pgAdmin we can download it from the following link as well Download PgAdmin


Next, you will need to enter the password and port details.


After finishing above step both PostgreSQL and pgAdmin will be installed on your machine.

For using pgAdmin go to windows search and search for pgAdmin, after clicking on that it will be open in the browser and will ask for a password in pop-up, after entering the password we have configured below screen will be open.


It comes with a default postgres database , we can create multiple databases by right-clicking on database -create-database and following screen will come where you can configure your new database details.


After entering all details click on save.

Conclusion

Here we have learn how to download PostgreSQL and pgAdmin on a windows machine

If you have any doubts let me know. 

Below the post, you may like to refer






Thanks
Happy Leaning.