Install PostgreSQL on Windows
Download and Installation Set-Up
To use PostgreSQL in your machine, you need to install:
1. Postgres database server
2. A graphical tool to administer and manage the database PgAdmin is the most popular GUI tool for Postgres.
Note: If you download and install the bundled installer that will take care of configuration settings.
You could download and install the individual database server and graphical tool but coupling the setting between these components will be a challenge.
Following steps indicate how to download and install PostgreSQL in windows machine:
Step 1 :
- Visit the link https://www.postgresql.org/download to download the latest release of PostgreSQL.
- Select the Windows option.
- Click on the download the installer
- Check the latest version of PostgreSQL for your operating system and click on a download
- Double click on the downloaded .exe file that will open the setup wizard, click on Next to proceed with an installation
- You can change the installation directory here if you want to
- Click on Next
- Select the components you want to install
- Click on Next
- leave the default directory or change the directory in which you want to store data
- Click on Next
- Enter the superuser (Postgres) password
- Click on Next
- Click on Next, don’t change the default port number
- Leave the default option as it is
- Click on Next
- This is the pre-installation summary
- Click on Next
- The set-up is now ready to install
- Click on Next
- Uncheck the stack builder option that will ask you for additional installation
- Click on Finish
- Select PgAdmin 4
- You will see PgAdmin homepage
- Select Servers -> PostgreSQL (11)
- Right click on it and select connect Server
- Enter the password to connect with the server
- Click on OK
- Using PgAdmin, i.e. GUI tool
- SQL shell (psql) through command prompt
- Open START menu
- Click on SQL shell
- Press Enter Key until prompt for the password
- Enter the password
Summary
- It is open-source object-oriented DBMS
- The source code is freely available
- It is a community project
- It is written in C language
- There is no maximum limit on database sizes