Install PostgreSQL

Before you start creating databases and writing SQL queries, you need a database management system installed on your computer. While MySQL is extremely popular, PostgreSQL is another powerful and widely used relational database system trusted by developers, startups, enterprises, and government organizations around the world.

In this lesson, you will learn what PostgreSQL is, why developers prefer it, how to install it on different operating systems, and how to verify that everything is working correctly.

By the end of this guide, you will have PostgreSQL installed and ready for SQL practice.

What is PostgreSQL?

PostgreSQL (often called "Postgres") is an open-source relational database management system (RDBMS) known for reliability, performance, and standards compliance.

Unlike many database systems that focus primarily on speed, PostgreSQL focuses on correctness, consistency, and advanced database features.

Many large organizations use PostgreSQL because it supports:

• Complex SQL queries
• Large databases
• Advanced indexing
• Strong security
• Data integrity
• High availability

PostgreSQL has been actively developed for decades and is considered one of the most advanced open-source databases available today.

Why Learn PostgreSQL?

Many beginners wonder why they should learn PostgreSQL when MySQL already exists.

The answer is simple.

PostgreSQL offers several advanced capabilities that make it highly attractive for professional software development.

Industry Adoption

Many modern companies use PostgreSQL as their primary database.

Examples include:

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

Standards Compliance

PostgreSQL closely follows SQL standards, making it an excellent platform for learning professional database development.

Advanced Features

PostgreSQL supports:

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

These features make PostgreSQL suitable for both beginners and experienced developers.

PostgreSQL Components

A PostgreSQL installation usually contains several components.

Understanding them helps you know what gets installed.

PostgreSQL Server

The server is the main component responsible for storing and managing databases.

Whenever an application connects to PostgreSQL, it communicates with the server.

Without the server, databases cannot function.

psql Command Line Tool

PostgreSQL includes a command-line interface called:

This tool allows you to execute SQL commands directly from the terminal.

Developers often use it for:

• Running queries
• Creating databases
• Managing users
• Troubleshooting

pgAdmin

pgAdmin is the official graphical administration tool for PostgreSQL.

Instead of typing commands, users can manage databases using a visual interface.

Beginners often find pgAdmin easier because it provides:

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

System Requirements

PostgreSQL runs on most modern computers.

Recommended requirements:

For learning purposes, almost any modern computer can run PostgreSQL comfortably.

Installing PostgreSQL on Windows

Windows users can install PostgreSQL using the official installer.

Step 1: Download PostgreSQL

Visit the official PostgreSQL website and download the latest stable version.

The installer package typically includes:

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

Always download the latest stable release unless a project specifically requires an older version.

Step 2: Launch the Installer

After downloading:

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

You will be guided through several configuration screens.

Step 3: Choose Installation Directory

The installer asks where PostgreSQL should be installed.

Example:

The default location is usually fine.

Most users should leave this setting unchanged.

Step 4: Select Components

You will see a list of available components.

Typical selections include:

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

For beginners, install everything.

This provides a complete PostgreSQL development environment.

Step 5: Set Database Password

PostgreSQL creates a special administrator account called:

You must create a password for this account.

Example:

Choose a strong password and store it safely.

You will need it whenever you connect to PostgreSQL.

Step 6: Configure Port Number

PostgreSQL uses a network port to accept connections.

Default port:

Most users should keep the default value.

Only change it if another application is already using this port.

Step 7: Complete Installation

Click:

and then:

The installation process may take several minutes.

Once completed, PostgreSQL is ready to use.

Installing PostgreSQL on Ubuntu Linux

Linux users can install PostgreSQL directly from the package manager.

First, update package information:

Install PostgreSQL:

The installation may take a few minutes depending on your internet connection.

Verify Installation

Check the installed version:

Example output:

This confirms PostgreSQL is installed successfully.

Starting PostgreSQL Service

After installation, PostgreSQL usually starts automatically.

To verify:

If necessary, start it manually:

Enable automatic startup:

This ensures PostgreSQL starts whenever the system boots.

Installing PostgreSQL on macOS

macOS users have multiple installation options.

The simplest method is downloading the official installer.

After installation:

Open Terminal and verify:

If a version number appears, PostgreSQL is installed correctly.

Connecting to PostgreSQL

Once PostgreSQL is installed, you can connect using:

You may be asked to enter your password.

After successful authentication, you will see:

This prompt indicates that PostgreSQL is ready to accept SQL commands.

Creating Your First Database

Let's create a simple database.

PostgreSQL responds:

The database has now been created.

Viewing Available Databases

To display all databases:

You should see:

This confirms that your database exists.

Connecting to a Database

To switch to the new database:

Output:

Now every query will run inside this database.

Creating Your First Table

Create a student table:

PostgreSQL will create the table successfully.

Insert Sample Data

Add some records:

The table now contains two rows.

Retrieve Data

Run:

Expected output:

Congratulations! You have executed your first PostgreSQL query.

Common Installation Problems

Port Already in Use

If PostgreSQL reports a port conflict, another application may already be using port 5432.

Changing the PostgreSQL port during installation usually solves the problem.

Incorrect Password

Many login issues occur because users forget the password created during installation.

Always save the password securely.

Service Not Running

If PostgreSQL fails to start:

Windows users should check:

Linux users can run:

Command Not Found

If the terminal cannot find:

the PostgreSQL installation path may not be added to the system PATH variable.

Restarting the system often resolves this issue.

PostgreSQL vs MySQL

Many developers compare PostgreSQL and MySQL.

PostgreSQL is often preferred for:

• Complex applications
• Advanced SQL features
• Data analytics
• Enterprise systems

MySQL is often preferred for:

• Simplicity
• Web applications
• Quick development

Both are excellent databases and valuable to learn.

Summary

PostgreSQL is one of the most powerful open-source database management systems available today. It offers strong SQL support, advanced features, excellent reliability, and enterprise-grade performance.

In this lesson, you learned:

• What PostgreSQL is
• Why developers use PostgreSQL
• How to install PostgreSQL
• How to connect to the server
• How to create databases
• How to create tables
• How to insert and retrieve data

Your PostgreSQL environment is now ready for learning SQL and building real-world database applications.

Next Step

Continue to the next lesson:

Install SQLite →