Skip to main content
HomeAbout SQLLearn SQL

How to Install PostgreSQL on Windows and Mac OS X

In this tutorial, you will learn how to install PostgreSQL on two different operating systems - Windows and Mac.
Feb 2019  · 6 min read

PostgreSQL is an open-source and light-weighted relational database management system (RDBMS). It is widely popular among developers and has been well-accepted by the industry. This tutorial is going to show you how you can install a specific version of PostgreSQL on either Windows or Mac.

How to Install PostgreSQL on Windows

PostgreSQL provides a nice graphical installer to install it. It is probably the easiest way to install PostgreSQL. For installing PostgreSQL on Windows, first head over to https://www.enterprisedb.com/downloads/postgres-postgresql-downloads and you should be provided with a table containing different distributions of PostgreSQL for different platforms -

PostgreSQL Distributions by Platform

PostgreSQL does not ask for any fancy requirements, and it runs mostly on a variety of commodity computers. So, system requirements' problem should not be there.

Assuming you are on Windows (32-bit version) platform and want to install the 9.4.21 version of PostgreSQL, you can click on the button as marked in the following figure -

PostgreSQL Distributions by Platform - Windows Install

Navigate to the location where the graphical installer got downloaded and double-click on it. It may vary from user to user depending on their administration schemes. You may have to run the installer as an administrator. Assuming you are already an administrator, double-clicking on the installer file will prompt you with a dialog box. The dialog box simply asks for your permission to install PostgreSQL on your computer. Click on Yes.

You will then get something like this -

PostgreSQL Setup - Windows

Click on Next. You will be prompted to specify the path of the destination folder in which you want to install PostgreSQL.

PostgreSQL Installation Directory - Windows

Specify the path and click on Next.

You will next see a dialog box asking you to specify the data directory of PostgreSQL. It is recommended to leave it as it appears -

PostgreSQL Data Directory - Windows

You will now be asked to enter a password to protect your PostgreSQL database system. It is highly advised that you provide one -

PostgreSQL Password Protection - Windows

PostgreSQL's services run on port number 5432. But PostgreSQL also lets you specify that after you enter and confirm your password -

PostgreSQL Port Number - Windows

It is recommended that you keep 5432 as it is.

You will then be asked to provide the Locale of the database. It is better to leave it to the Default one as shown the following figure and click on Next-

PostgreSQL Locale Selection - Windows

PostgreSQL is now finally ready to get installed on your Windows computer. And you are left with just one click (on Next)-

PostgreSQL Ready to Install - Windows

Your PostgreSQL installation should now have started. It won't take much time. Towards the very end of the installation process, you will be prompted to check/uncheck to launch StackBuilder. You can uncheck that and click on Finish.

Completing PostgreSQL Setup Wizard - Windows

Testing your PostgreSQL Installation on Windows

After you are done installing PostgreSQL, you can verify if the installation was correct or not. For this, simply press the Windows button from your keyboard and type psql. Select the option that says SQL Shell (psql). The SQL Shell of PostgreSQL looks just like the command-prompt -

SQL Shell (psql)

Hit Enter four times in case you followed all the default settings while installing PostgreSQL. Otherwise, you will have to specify all the values as needed by psql manually. Finally, give the password you provided during the installation and hit Enter. If you get the postgres=# prompt, then your installation was all correct.

SQL Shell (psql) 2

You will now see how to install the same version of PostgreSQL on a Mac computer.

How to Install PostgreSQL on Mac OS X

To install PostgreSQL on a Mac computer, head over to https://www.enterprisedb.com/downloads/postgres-postgresql-downloads and click on the button as shown in the following figure (version 9.4.21) -

PostgreSQL Distributions by Platform - Mac OS X Install

Now, navigate to the location where the installer got downloaded.

PostgreSQL Installer - Mac OS X

Double-click on the installer file. And you will be provided with another folder containing two files - PostgreSQL Installer Folder - Mac OS X

Double-click on this file -

PostgreSQL Installer - Mac OS X

You will be asked to either Cancel or Open further. In order to continue the installation, click on Open.

PostgreSQL Installer File Window - Mac OS X

You will then be prompted to enter your password for your Mac OS X. PostgreSQL Installer Password Prompt - Mac OS X

After entering your password, click on OK. You will then see something like this -

PostgreSQL Setup - Mac OS X

Simply, click on Next.

Now, everything is exactly the same with the Windows' installation steps. Once you are done installing PostgreSQL, you can test if it was correct.

Testing your PostgreSQL Installation on Mac OS X

To test the installation, simply click on Launchpad and type psql. You should get the following if you do so -

Launchpad search psql

Click on it and then you will get a prompt like this -

psql window - Mac OS X

You will be asked to enter the details, and the values may vary from user to user. If you followed the default installation without changing any of the values during the installation, just hit Enter four times and enter the password you provided during the installation.

If you get the psql prompt, i.e. postgres=# then your installation is correct.

Taking it Further

You now know how you can install PostgreSQL on your computer. If you are looking to hone your SQL skills using PostgreSQL here are some of the resources that might help you:

Related courses

Joining Data in SQL

BeginnerSkill Level
4 hr
78.6K
Level up your SQL knowledge and learn to join tables together, apply relational set theory, and work with subqueries.
See DetailsRight Arrow
Start Course
See MoreRight Arrow
Related

The 80 Top SQL Interview Questions and Answers for Beginners & Intermediate Practitioners

This article provides a comprehensive overview of 80 essential SQL questions and answers for job hunters, hiring managers, and recruiters, covering both general topics and technical questions.
Elena Kosourova's photo

Elena Kosourova

33 min

10 Portfolio-Ready SQL Projects for All Levels

Select your first—or next—SQL project to practice your current SQL skills, develop new ones, and create an outstanding professional portfolio.
Elena Kosourova's photo

Elena Kosourova

11 min

How to Use SQL in pandas Using pandasql Queries

Unleash the power of SQL within pandas and learn when and how to use SQL queries in pandas using the pandasql library for seamless integration.
Elena Kosourova's photo

Elena Kosourova

8 min

How to Practice SQL Using any Dataset with Workspace

Learn how DataCamp Workspace optimizes the experience of working with Jupyter notebooks and SQL. Discover how to effortlessly write SQL queries, connect to databases, analyze CSV files, and leverage the power of AI assistance
Richie Cotton's photo

Richie Cotton

9 min

QUALIFY: The SQL Filtering Statement You Never Knew You Needed

Learn about the SQL QUALIFY clause, an essential yet lesser-known filtering method in SQL. Understand its syntax, uses, and how it differs from other SQL filtering methods.
Kurtis Pykes 's photo

Kurtis Pykes

8 min

MySQL Tutorial: A Comprehensive Guide for Beginners

Discover what MySQL is and how to get started in one of the most popular database management systems.
Javier Canales Luna's photo

Javier Canales Luna

15 min

See MoreSee More