Title

PostgreSQL Database Installation

Database Installation

Now Watching

—

First Lesson

Lesson Progress

🎉 Section Done!

See next section →

📄 View Reference Document & Notes

📋 Lesson Notes & Resources

PostgreSQL Installation (Windows 10 / 11)

Step-by-Step

Follow these steps to download, install, and verify PostgreSQL and pgAdmin on your Windows machine.

1. Prerequisites

●

Operating System: Windows 10 / Windows 11 (64-bit preferred).

●

Administrator access to install new software.

●

Minimum 2 GB free disk space.

Tip: Close other heavy applications before installation for a smoother experience.

2. Download PostgreSQL Installer

Open your browser and go to the official PostgreSQL downloads page:

https://www.postgresql.org/download/windows/

Scroll to "Windows" section and click on the installer link provided by EDB (EnterpriseDB).

Choose the latest stable version (for example: PostgreSQL 16.x) and download the Windows x86-64 installer.

3. Run the Installer & Choose Components

Locate the downloaded .exe file (for example: postgresql-16.x-windows-x64.exe) and double-click to start the setup.

On the Setup Wizard, click Next on the welcome screen.

Choose the Installation Directory (default is usually C:\Program Files\PostgreSQL\<version>) and click Next.

In the "Select Components" screen, keep the following selected:

PostgreSQL Server, pgAdmin, Stack Builder (optional), Command Line Tools

4. Configure Superuser Password & Port

When prompted for database superuser password (user: postgres):

● Enter a strong password.
● Confirm the password.
● Write it down safely – you will use this to connect later.

On the Port screen, keep the default port 5432 unless it is already in use. Click Next.

Choose the default Locale (usually your system locale) and proceed.

5. Install & Verify PostgreSQL Service

Review the summary and click Next to start the installation.

Wait until all components are installed. This may take a few minutes.

After completion, you can uncheck "Launch Stack Builder" (optional) and click Finish.

To verify service:
Open Services in Windows and confirm that the service name "postgresql-x64-<version>" is in Running state.

6. Open pgAdmin & Make First Connection

Click on Start Menu → PostgreSQL → pgAdmin to open pgAdmin.

The first time, pgAdmin will ask you to set a master password for storing connection details securely.

In the left Browser panel, click on the "PostgreSQL <version>" server. Enter the postgres user password you configured during installation.

Once connected, you should see Databases, Schemas, and other objects.

7. Verify Installation with a Test Query

Run a simple SQL command to confirm PostgreSQL is working correctly.

In pgAdmin, right-click on Databases → postgres and choose Query Tool.

Paste and execute the following query:

SELECT version();

If you see the PostgreSQL version details in the output, your installation is successful.