PostgreSQL is one of the most popular open-source relational database management systems used for web applications, backend systems, analytics platforms, and enterprise software. It is known for its reliability, powerful SQL capabilities, extensibility, and support for modern application development.
If you are learning PostgreSQL or preparing a development environment for a new project, the first step is installing PostgreSQL correctly on your operating system.
In this guide, we will explain how to install PostgreSQL on Windows, macOS, and Linux, how to verify the installation, connect to the PostgreSQL server, and perform some basic configuration.
What Is PostgreSQL?
PostgreSQL is an open-source object-relational database management system (ORDBMS). It allows applications to store, manage, retrieve, and analyze structured data using SQL.
PostgreSQL is commonly used with technologies such as:
- Java and Spring Boot
- Node.js
- Python and Django
- PHP
- .NET
- React and Next.js applications
- REST APIs
- SaaS applications
- Enterprise applications
Before installing PostgreSQL, make sure your computer has enough available storage and that you have administrator or sudo access when required.
Installing PostgreSQL on Windows
Installing PostgreSQL on Windows is relatively straightforward because the official installer provides PostgreSQL along with commonly used tools.
Step 1: Download PostgreSQL
Visit the official PostgreSQL download page and select Windows.
Download the appropriate installer for your system.
The Windows installer typically includes:
- PostgreSQL database server
- pgAdmin
- Command-line tools
- Stack Builder
Step 2: Start the Installer
Run the downloaded installer as an administrator.
The installation wizard will guide you through several configuration screens.
Choose the installation directory or keep the default location.
Step 3: Select Components
You can normally keep the default components selected.
The important components include:
- PostgreSQL Server
- pgAdmin 4
- Command Line Tools
pgAdmin provides a graphical interface for managing PostgreSQL databases, while command-line tools allow you to work with PostgreSQL from a terminal.
Step 4: Set the PostgreSQL Password
During installation, you will be asked to create a password for the PostgreSQL database superuser.
The default administrative username is usually:
postgres
Choose a strong password and keep it somewhere secure because you will need it when connecting to the database.
Step 5: Configure the Port
PostgreSQL uses port 5432 by default.
Unless another application is already using this port, you can keep the default value.
Step 6: Complete the Installation
Continue through the remaining installation screens and click Install.
After the installation finishes, PostgreSQL should be running as a Windows service.
Step 7: Verify PostgreSQL
Open Command Prompt or PowerShell and run:
psql --version
If PostgreSQL was installed and configured correctly, you should see the installed PostgreSQL version.
You can also open pgAdmin 4 from the Windows Start menu to manage your databases using a graphical interface.
Installing PostgreSQL on macOS
There are several ways to install PostgreSQL on macOS. Homebrew is one of the most convenient options for developers.
Step 1: Install Homebrew
If Homebrew is not already installed, install it from the official Homebrew website.
Once Homebrew is available, open Terminal.
Step 2: Install PostgreSQL
Run:
brew install postgresql
Homebrew will download and install PostgreSQL and its required dependencies.
Step 3: Start PostgreSQL
After installation, start the PostgreSQL service with:
brew services start postgresql
This starts PostgreSQL as a background service.
Step 4: Check the Installation
Run:
psql --version
You should see the installed PostgreSQL version.
Step 5: Connect to PostgreSQL
Try connecting using:
psql postgres
If the connection is successful, you will enter the PostgreSQL command-line interface.
You can exit the PostgreSQL shell using:
\q
Alternative macOS Installation
Developers who prefer a graphical installer can also use a PostgreSQL distribution such as Postgres.app. This provides a convenient way to install and manage PostgreSQL on macOS.
Installing PostgreSQL on Ubuntu Linux
PostgreSQL can be installed easily on Ubuntu and other Debian-based Linux distributions using the package manager.
Step 1: Update Package Information
Open Terminal and run:
sudo apt update
This updates the local package information.
Step 2: Install PostgreSQL
Run:
sudo apt install postgresql postgresql-contrib
The command installs the PostgreSQL server and additional utilities.
Step 3: Check PostgreSQL Status
After installation, check whether PostgreSQL is running:
sudo systemctl status postgresql
If the service is running, you should see an active status.
Step 4: Start PostgreSQL
If PostgreSQL is not running, start it with:
sudo systemctl start postgresql
You can also enable PostgreSQL to start automatically when the system boots:
sudo systemctl enable postgresql
Step 5: Check the PostgreSQL Version
Run:
psql --version
This confirms that the PostgreSQL command-line client is installed.
Connecting to PostgreSQL on Linux
Ubuntu usually creates a PostgreSQL operating-system user called postgres.
You can switch to that user with:
sudo -u postgres psql
If everything is configured correctly, you will enter the PostgreSQL shell.
You can check the PostgreSQL version from inside the shell:
SELECT version();
To exit:
\q
Creating Your First PostgreSQL Database
Once PostgreSQL is installed, you can create a database to test your setup.
Inside the PostgreSQL shell, run:
CREATE DATABASE myapp;
To see available databases, use:
\l
To connect to your new database:
\c myapp
You can now start creating tables and working with your application data.
For example:
CREATE TABLE users (
id SERIAL PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(150) UNIQUE
);
You can insert test data using:
INSERT INTO users (name, email)
VALUES ('John Doe', 'john@example.com');
Then retrieve the data:
SELECT * FROM users;
Using pgAdmin
If you prefer a graphical interface instead of the command line, pgAdmin is a popular PostgreSQL administration tool.
With pgAdmin, you can:
- Create and delete databases
- Create tables
- Run SQL queries
- Manage users and roles
- Create indexes
- Inspect database structures
- Monitor database activity
- Manage PostgreSQL servers
For beginners, pgAdmin can make it easier to understand how PostgreSQL databases are organized.
Common PostgreSQL Installation Problems
PostgreSQL Command Not Found
If you see an error such as:
psql is not recognized
or:
command not found: psql
your PostgreSQL bin directory may not be included in your system’s PATH.
Add the PostgreSQL installation’s bin directory to your PATH and restart the terminal.
Port 5432 Is Already in Use
PostgreSQL normally uses port 5432.
If another application is already using that port, PostgreSQL may fail to start.
You can identify the conflicting process or configure PostgreSQL to use another available port.
Authentication Failed
If PostgreSQL rejects your password, make sure you are using the correct username and password.
On many installations, the default administrative username is:
postgres
PostgreSQL Service Is Not Running
If your application cannot connect to PostgreSQL, first check whether the PostgreSQL service is running.
On Linux:
sudo systemctl status postgresql
On macOS with Homebrew:
brew services list
On Windows, PostgreSQL can be checked through the Windows Services application.
PostgreSQL Installation Checklist
After installation, verify the following:
- PostgreSQL is installed
- PostgreSQL service is running
psql --versionworks- You can connect to the PostgreSQL server
- You know your database username and password
- Port 5432 is available or correctly configured
- pgAdmin works if you installed it
- You can create and access a test database
Conclusion
Installing PostgreSQL is the first step toward building applications that require a reliable and powerful relational database. Whether you are using Windows, macOS, or Linux, PostgreSQL provides flexible installation options for both beginners and professional developers.
Once PostgreSQL is installed, you can start learning SQL, creating databases and tables, managing users, building relationships between data, and connecting PostgreSQL with backend technologies such as Java, Spring Boot, Node.js, Python, and Django.
For developers building modern applications, learning PostgreSQL is a valuable skill because it provides a strong foundation for working with structured data, APIs, scalable backend systems, and production applications.
