Install PostgreSQL

Before you can write SQL queries, you need a database installed. MySQL is popular, but PostgreSQL is another powerful option that many developers swear by.

In this guide, I'll show you what PostgreSQL is, why you might choose it over MySQL, how to install it on your OS, and how to verify it's working.

By the end, you'll have PostgreSQL up and running.

Why Learn PostgreSQL?

Some beginners ask: "Why not just stick with MySQL?"

Good question. PostgreSQL has some serious advantages for professional developers.

Industry Adoption

You'll find PostgreSQL powering:

• Financial applications
• Analytics platforms
• SaaS products
• Enterprise software
• Government systems

Learning it is learning what real companies use.

Standards Compliance

PostgreSQL follows SQL standards closely. This makes it excellent for learning database development the right way.

Advanced Features

It gives you:

• Window Functions
• Common Table Expressions (CTEs)
• Materialized Views
• JSON Data
• Full Text Search
• Custom Functions

These features work whether you're a beginner or a seasoned dev.

PostgreSQL Components

When you install PostgreSQL, you get several pieces. Understanding them helps:

PostgreSQL Server

The core component. It stores and manages your databases. Your applications connect to this server to access data. Without it, nothing works.

psql Command Line Tool

A command-line interface called:

You can execute SQL directly from the terminal using it. Developers use it for:

• Running queries
• Creating databases
• Managing users
• Troubleshooting

pgAdmin

The official GUI for PostgreSQL administration. Instead of typing commands, you click through a web interface. Beginners often prefer it because it gives you:

• Database explorers
• Query editors
• Table management tools
• Backup utilities

System Requirements

Nothing exotic. Here's what you should have:

Any modern computer can run PostgreSQL comfortably for learning.

Installing PostgreSQL on Windows

Windows gives you a straightforward installer.

Step 1: Download PostgreSQL

Go to the official PostgreSQL website and grab the latest stable version.

You'll get:

• PostgreSQL Server
• pgAdmin
• Command Line Tools
• Additional Utilities

Always grab the latest stable release unless you have a specific reason not to.

Step 2: Launch the Installer

After downloading:

1. Double-click the installer.
2. Grant administrator permissions.
3. Start the wizard.

You'll be walked through several configuration screens.

Step 3: Choose Installation Directory

The installer asks where PostgreSQL should live.

Example:

The default is usually fine. Leave it alone unless you have a reason to change it.

Step 4: Select Components

You'll see a list. Select what you want:

• PostgreSQL Server
• pgAdmin
• Command Line Tools
• Stack Builder

For beginners, install everything. You'll have a complete environment.

Step 5: Set Database Password

PostgreSQL creates an admin account called:

You need a strong password for this:

Store it somewhere safe. You'll need it to connect to PostgreSQL.

Step 6: Configure Port Number

PostgreSQL listens on:

Keep the default unless something else is already using it.

Step 7: Complete Installation

Click:

then:

Installation takes a few minutes. Once done, PostgreSQL is ready.

Installing PostgreSQL on Ubuntu Linux

Linux users just use the package manager.

First, refresh your packages:

Install PostgreSQL:

Takes a few minutes depending on your connection.

Verify Installation

Check what version you have:

You'll see something like:

Good. It's installed.

Starting PostgreSQL Service

After installation, PostgreSQL usually starts automatically.

Check:

Need to start it manually?

Make it auto-start on boot:

Now PostgreSQL launches whenever your system boots.

Installing PostgreSQL on macOS

macOS users can download the official installer.

After installation, open Terminal and verify:

A version number means you're good.

Connecting to PostgreSQL

Once installed, connect with:

Enter your password when prompted.

You'll see:

This prompt means PostgreSQL is waiting for your commands.

Creating Your First Database

Let's create a simple database:

PostgreSQL responds:

CREATE DATABASE

Your database exists.

Viewing Available Databases

List all databases:

You'll see:

postgres
template0
template1
SchoolDB

There's your database.

Connecting to a Database

Switch to your new database:

Output:

You are now connected to database "SchoolDB"

All future queries run inside this database.

Creating Your First Table

Create a student table:

PostgreSQL creates the table.

Insert Sample Data

Add some records:

Two rows now exist in your table.

Retrieve Data

Run:

Expected output:

Congratulations! You've written and executed your first PostgreSQL query.

Common Installation Problems

Port Already in Use

If PostgreSQL complains about port 5432 already being used, another app has it. Change PostgreSQL's port during installation and you're done.

Incorrect Password

Many login failures happen because people forget the password they created during setup. Save it somewhere.

Service Not Running

PostgreSQL won't start? Windows users should check: