How To Download And Install Postgresql In Windows

To apply Postgre in your motorcar, you need to install:

1. Postgre Database Server
2. A graphical tool to administer and manage the DB. pgAdmin is the about popular tool GUI Tool for Postgre

Yous could individually Download PostgreSQL for Windows and install these components but coupling the settings between the DB server, and a GUI tool could be a challenge. It's all-time to use a bundled installer which takes care of configuration complexities.

How to Download & Install PostgreSQL

Following is a step past step procedure on How to Install PostgreSQL on Windows Machine:

Step 1) Open your browser.
Become to https://www.postgresql.org/download and select Windows

Step 2) Check options.
You are given two options 1) Interactive Installer by EnterpriseDB and 2) Graphical Installer past BigSQL.

BigSQL currently installs pgAdmin version 3 which is deprecated. It's best to choose EnterpriseDB which installs the latest version four

Pace 3) Select PostgreSQL version.

1. Y'all will be prompted to desired PostgreSQL version and operating system. Select the latest PostgreSQL version and OS as per your environment
2. Click the Download Push button

Download volition begin

Step 4) Open exe file.
Once you Download PostgreSQL, open the downloaded exe and Click next on the install welcome screen.

Step 5) Update location.

1. Change the Installation directory if required, else leave it to default
2. Click Next

Step six) Select components.

1. You may choose the components you want to install in your arrangement. You may uncheck Stack Builder
2. Click Next

Step vii) Check data location.

1. You may change the data location
2. Click Next

Step viii) Enter countersign.

1. Enter super user password. Make a note of it
2. Click Next

Step nine) Bank check port option.

1. Leave the port number default
2. Click Next

Step ten) Check summary.

1. Check the pre-installation summary:
2. Click Next

Step eleven) Prepare to install.
Click the adjacent push.

Step 12) Check stack architect prompt.
Once install is consummate you lot will meet the Stack Builder prompt

1. Uncheck that option. We will use Stack Builder in more advance tutorials
2. Click End

Pace 13) Launch PostgreSQL.
To launch PostgreSQL go to Start Menu and search pgAdmin iv

Step 14) Check pgAdmin.
Y'all will see pgAdmin homepage.

Step 15) Notice PostgreSQL 10.
Click on Servers > PostgreSQL x in the left tree

Step 16) Enter password.

1. Enter super user countersign set during installation
2. Click OK

Step 17) Check Dashboard.
You will see the Dashboard

That's information technology to PostgreSQL installation.

As well Bank check:- PostgreSQL Tutorial for Beginners: Learn Bones PSQL in three Days

Source: https://www.guru99.com/download-install-postgresql.html

Posted by: ramseythipper82.blogspot.com

Share this post