How to Install PostgreSQL on Windows (Step-by-Step)

Описание: 📌 In this video, I'll show you how to install PostgreSQL on Windows step by step. Whether you're a beginner or just need a refresher, this guide covers everything you need to get started.

🧠 Reminder: PostgreSQL follows a server–client model.
The server stores your data, and clients like pgAdmin (GUI) or psql (CLI) connect to it.

🔧 Steps Covered in the Video:

Step 1: Download PostgreSQL
Go to https://www.postgresql.org/download/w...
Click the EnterpriseDB link and download the installer.

Step 2: Run the Installer
Double-click the .exe file
Click "Yes" if prompted

Step 3: Set Install Location
Use default: C:\Program Files\PostgreSQL\17\
Click "Next".

Step 4: Choose Components
Leave defaults checked:
PostgreSQL Server
pgAdmin (GUI client)
Stack Builder (optional add-ons)
Command Line Tools (includes psql shell for terminal access)

Step 5: Create Superuser Password
Set a password for the postgres user
You'll use this in pgAdmin, psql shell, and scripts

Step 6: Configure Port and Locale
Leave port as 5432.
Leave locale as default (for language and formatting)

Step 7: Install
Click "Next" to begin installation
Click "Finish" when done
A default database named postgres is created automatically

Step 8: Open pgAdmin 4 (Client)
Open pgAdmin from Start Menu.
Enter your password to connect to the PostgreSQL server and access the postgres database.

Step 9: Open psql Shell (Command Line Interface)
Open SQL Shell (psql) from the Start Menu
Just press Enter to accept the defaults, then enter your password when asked
postgres=# SELECT version();

If this helped, don’t forget to like, comment, and subscribe for more tutorials!

#postgresql #pgadmin #programming