Intro

I am creating a new series about PostgreSQL.

In this short article, we will learn how to install it.

What is PostgreSQL?

• a free and open-source relational database management system (RDBMS) to manage data
• primarly uses SQL (Structured Query Language) to write commands
• primarly stores data in tables consisting columns and rows
• can get easily connected to backend applications (e.g. in Node, Python, Java etc.)
• comes with a terminal-based front-end named psql

---

How To Install it?

Windows

1. Go to the PostgreSQL download page
2. Follow the instructions

macOS

1. Go to the PostgreSQL download page
2. Follow the instructions

Ubuntu

1. Go to the PostgreSQL download page
2. Follow the instructions

Arch

1. pacman -S postgresql

---

Further Reading

• PostgreSQL Homepage
• PostgreSQL Download
• PostgreSQL on Wikipedia
• SQL Syntax

---

Questions

• What’s your favorite SQL database?