How to install PostgreSQL - 13 on windows 10 | 2020

preview_player
Показать описание
PostgreSQL was developed for UNIX-like platforms, however, it was designed to be portable. It means that PostgreSQL can also run on other platforms such as macOS, Solaris, and Windows.
Since version 8.0, PostgreSQL offers an installer for Windows systems that makes the installation process easier and faster. For development purposes, we will install PostgreSQL version 13 on Windows 10.
=============================================
For any Business enquiry contact us
WhatsApp :- +917978073704 (for only business query)
=============================================

There are three steps to complete the PostgreSQL installation:
Download PostgreSQL installer for Windows
Install PostgreSQL
Verify the installation

First, you need to go to the download page of PostgreSQL installers on the EnterpriseDB.
It will take a few minutes to complete the download.

To install PostgreSQL on Windows, you need to have administrator privileges.
Step 1. Double click on the installer file, an installation wizard will appear and guide you through multiple steps where you can choose different options that you would like to have in PostgreSQL.

Step 2. Click the Next button

Step 3. Specify installation folder, choose your own or keep the default folder suggested by PostgreSQL installer and click the Next button

Step 4. Select software components to install:

The PostgreSQL Server to install the PostgreSQL database server
pgAdmin 4 to install the PostgreSQL database GUI management tool.
Command Line Tools to install command-line tools such as psql, pg_restore, etc. These tools allow you to interact with the PostgreSQL database server using the command-line interface.
Stack Builder provides a GUI that allows you to download and install drivers that work with PostgreSQL.

For the tutorial on this website, you don’t need to install Stack Builder so feel free to uncheck it and click the Next button to select the data directory:

Step 6. Enter the password for the database superuser (postgres)

PostgreSQL runs as a service in the background under a service account named postgres. If you already created a service account with the name postgres, you need to provide the password of that account in the following window.

After entering the password, you need to retype it to confirm and click the Next button:

Step 7. Enter a port number on which the PostgreSQL database server will listen. The default port of PostgreSQL is 5432. You need to make sure that no other applications are using this port.

Step 8. Choose the default locale used by the PostgreSQL database. If you leave it as default locale, PostgreSQL will use the operating system locale. After that click the Next button.
Step 9. The setup wizard will show the summary information of PostgreSQL. You need to review it and click the Next button if everything is correct. Otherwise, you need to click the Back button to change the configuration accordingly
The installation may take a few minutes to complete.
Step 10. Click the Finish button to complete the PostgreSQL installation.

There are several ways to verify the PostgreSQL installation. You can try to connect to the PostgreSQL database server from any client application e.g., psql and pgAdmin.

The quick way to verify the installation is through the psql program.

First, click the psql application to launch it. The psql command-line program will display.
Now, you’re ready to install PostgreSQL on your computer. Click the Next button to begin installing PostgreSQL.
Рекомендации по теме
Комментарии
Автор

Thanks i was trying to install mysql whole day faced many issue
You just did this In 5 mins

vishalvekaria
Автор

tried many times to install on windows 10 but im getting this error.
psql: error: could not connect to server: Connection refused

jonecane
Автор

PostgreSQL 🐘 Number one Database! Thanks video bro ✌️✊

nouchance
Автор

MashaAllah ..
Nicely explain keep it up friend

islamiyazindagi
Автор

pgadmin4 is not opening.... tried reinstalling many times do you have any solution to it

babumishra
Автор

3:13 better uncheck this option than closing window at 3:24. My installation is incomplete if I close installation window.

jumbo
Автор

Thank you so so much Please upgrade your microphone. I had to strain my ears to hear you

And you can enable subtitles also... Thanks once again

kingmed
Автор

You must select at least one package to install before you continue I am getting this error

lakshmammakrishnappa
Автор

mine is struck in initialiazing clusters ; (

staplepin
Автор

good job creating this video. One suggestion though... the music at the beginning is very loud and annoying, other than that good explanation

otroleonarbe
Автор

very useful video sir keep up the good work

rohankademani
Автор

The setup doesnt ever appear, it shows the logo and then disappears, the postgres installer is still running in the background but nothings happens, my antivirus is disabled and I have the correct version for my computer.

teratomate
Автор

thanks for your video. Do you have any video talk about how to enable openssl with Potgresql on Windows 10?

mihuynh
Автор

the autoinstalling isnt work, link 'start the downloading now' too, i can download postgresql

hollymood
Автор

thanks a lot .. you save the my time /

somu
Автор

I installed the same version but I don't have the PostgreSQL 13 in the Servers 3:47

Renekawa
Автор

please upgrade microphone the sound leaves much to desire in ones ears. Liked and subscribed.

johnrockets