Install PostgreSQL 14.7 on Windows

In this tutorial, you’ll learn how to install PostgreSQL 14.7 on Windows 10.

The process is straightforward and consists of the following steps:

1. Install PostgreSQL
2. Configure Environment Variables
3. Verify the Installation
4. Download the Northwind PostgreSQL SQL file
5. Create a New PostgreSQL Database
6. Import the Northwind SQL file
7. Verify the Northwind database installation
8. Connect to the Database Using Jupyter Notebook

Prerequisites

• A computer running Windows 10
• Internet connection

1. Download the official PostgreSQL 14.7 at https://get.enterprisedb.com/postgresql/postgresql-14.7-2-windows-x64.exe
2. Save the installer executable to your computer and run the installer.

Note: We recommend version 14.7 because it is commonly used. There are newer versions available, but their features vary substantially!

Step 1: Install PostgreSQL

We’re about to initiate a vital part of this project — installing and configuring PostgreSQL.