How to install PostgreSQL ?

Installing PostgreSQL is very easy you just have to go to POSTGRESQL download website and download the postgresql-version.exe file and then follow the below steps.

Photo by Setu Chhaya on Unsplash
  1. After downloading the postgre exe file from the official websites now run it.
  2. Now welcome page will appear just click on next.
Welcome page

3. Now it will ask you for installation directory just click on next button.

Installation directory

4. It will ask you select the component lists you want to install. I have selected all the list as all are required for our purpose. These lists are PostgreSQL server, pgAdmin4, Stack Builder, Command Line Tools. Now let’s understand the use of each components.

PostgreSQL server:- This component is used for running the database on the machine.

pgAdmin4:- This is GUI based application used for management of PostgreSQL database.

Stack Builder:- This tool is used to install other additional components related to PostgreSQL.

Command Line Tool:- This is used for managing the PostgreSQL database through CMD.

Component List

5. Now it will ask you to select the location where data is going to be store. Just select the location and click on next.

Data location

6. Now next screen will ask you to setup a superuser password for the database. Add the password and remember this password will used while login into database.

Super user password

7. Now it will ask you to enter the port number for database server to listen on. Click on next after entering the port number.

Port number

8. It will ask you to select the locale just let it be default and click on next.


9. It will show the installation summary meaning what all things it is going to install in your machine just click on next.

installation summary

10. One more screen will come just click on next then it will install the component after installation one screen just click on finish.

11. Now go to start and search for pgAdmin and run it as administrator. It will ask you to setup a master password, enter the password and remember this master password will be required each time you launch the pgAdmin. Expand the servers list postgreSQL will come and now expand that as well. After expanding postgreSQL it will ask you the superuser password. After entering password it will show the database details.

Thank you for reading please comment your suggestions, share the article, follow me and Abhima Database Technology publication.

Bhagavad Gita Verse of the Day

निर्मानमोहा जितसङ्गदोषा
अध्यात्मनित्या विनिवृत्तकामा: |
द्वन्द्वैर्विमुक्ता: सुखदु:खसंज्ञै
र्गच्छन्त्यमूढा: पदमव्ययं तत् || 5||

nirmāna-mohā jita-saṅga-doṣhā
adhyātma-nityā vinivṛitta-kāmāḥ
dvandvair vimuktāḥ sukha-duḥkha-sanjñair
gachchhanty amūḍhāḥ padam avyayaṁ tat

BG 15.5: Those who are free from vanity and delusion, who have overcome the evil of attachment, who dwell constantly on the self and on God, who are free from the desire to enjoy the senses, and are beyond the dualities of pleasure and pain, such liberated personalities attain My eternal Abode.



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Vishal Pathak

Vishal Pathak


love ❤ coding, solving some industry problems technologies: JavaScript, C#, Angular, PLSQL, Docker Want to learn: Python, Go language, AI, ML and Cloud